Ubuntu
openoffice.org package

Request display formats to support Fitness/Duration

Asked by Quentin Neill

Feature Request:

I want to display duration (seconds, minutes, hours) in the traditional Time formats, so that the value can be used in Fitness related things like interval times, total times, avg times, MPH calculations. For example, if I enter 205.5 (for seconds) I'd like to display that as 3:25.5, and then use that to calculate (for a 1.5 mile cycling interval) a field that shows 24.270mph.

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
GercoKees
Solved:
Last query:
Last reply:
Revision history for this message
Best GercoKees (gercokees) said : 		#1

hi,
dates and times are entered as fractions of days. Therefore: try this:
A1: 205.5
A2: =A1/(60*60*24)

now, format A2 (> format > cells and choose category time and choose the one you like... you can also enter the following string into the formatcode: "[UU]:MM:SS,00" (without the "")

I am not sure what you like to do with the 1.5 mile cycling-interval, so i can not provide a solution for that one. Please do not hesitate to ask when you have some more information....

Succes,

Revision history for this message
Quentin Neill (qneill) said : 		#2

Thanks. So the short answer is I can do what I need, it's just difficult. I was already doing something like that:

miles 3
mins 7
secs 54
mph (miles*3600)/((mins*60)+secs)

But then I started tracking intervals and it was a pain to sum the miles, seconds, minutes, calculate the rates for each interval, etc.

Revision history for this message
Quentin Neill (qneill) said : 		#3

Thanks GercoKees, that solved my question.