Read section 4. Times in cells in Ten concepts that every Calc user should know. Perhaps you want a duration instead of clock time. If you need additional assistance describe precisely what "stopwatch format" means. Give an example of the calculation you would like to do.ETobias wrote:One function that I think is missing in spreadsheets, and not just in OpenOffice, is the ability to calculate time that is in a "stopwatch" format.
a "stopwatch" format.
[S]" s"
[S].00" s"
[M]" min "SS.00" s"
[M]" min "SS" s"
[H]" h"MM" min"SS" s"
ETobias wrote:Isn't everything listed above related to time of day? I want to do some calculations related to race times (running). I am able to get around it by manual calculations, i.e., trunc (to determine minutes), (D1-trunc(D1))*60 (to determine seconds). This works but it would be nice to have something easier and more elegant.
0:2:13.605 for a time of 2 min 13.605 s
As an example, T2=T1*((D2/D1)^1.06) Where T1 and T2 are times in minutes and seconds and D1 and D2 are distances. I was able to do it by entering the minutes and second in separate cells and do the calculations. It just seems that it should be an easier way.
OOo 2.3.X on Ms Windows XP + Windows 2000
Users browsing this forum: Google [Bot] and 21 guests