Hi Derek,
Formatting the cells using mm:ss will display only minutes and seconds.
That is, hours are not displayed. In your example, you'd still have to
enter the hours i.e. 0:42:34. What will be displayed is 42:34. In the
second cell entering 0:24:33 will display 24:33. Unfortunately, when
you add them, the cell formatted mm:ss will display 07:07. If you want
to show the sum of the minutes, you'll have to use a formula that parses
the string into minutes and seconds, does the addition, then creates a
new string formatted the way you want.
tc
Joe Conner wrote:
Input your time as 00:42:34 and 00:24:33 and then they will sum as
01:07:07.
Derek J. Carr wrote:
Hello,
Using OOo 2.0 on windows XP + SP2 (but it seems to be the same in
1.1.4). This is my first time in trying to use calc to do time
calculations, and I'm having trouble with the formating. I've looked
at most of the user docs that I can find, and very little is said
about time formating. Basically I want a 'true' format of MM:SS both
for input and for output. So I'd like to input "42:34" and have
interpreted as 42 min and 34 sec, not 42 hours and 34 min - which is
what it seems to be doing at the moment and then just showing the
minutes and seconds part. I'd then like a cell to show 73:05 when
added to a cell with 24:33. I think this might be a bug. I looked at
issue tracker, but it's a complected item to search for.
---------------------------------------------------------------------
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]
