Hi Brian
never use a single h in front of the user-format-string, this format
allows more then 9 full hours you could give a sign for the thousand and
so on.
Sincerely
Franz
Brian Barker schrieb:
At 17:26 24/03/2009 +0100, Franz Wein wrote:
At 13:50 24/03/2009 +0200, Hylton Conacher wrote:
My values are entered so:
Distance(km) Time(0.mmss)
3.2 0.3407
I believe he could write this value of time (normal hh:mm:ss) in the
user-format hh.mmss.
--> 12hours 10min 33 seconds are shown as 12:10:33 respectively as
12.1033
You could define a column, a row or a cell in this way, and all other
works well like all time formulas in calc. But it is necessary to
define this!
Aha: you are cleverer than me! (Or even h.mmss)
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
