Anthony Chilco wrote:
Hi Derek,
I've attached a sample calc file with two basic functions. One writes
minutes and seconds in the format you want. The other takes that type
of string and converts it back to seconds. In order to get the display
you want, format the cells as 'text'. You'll be able to enter
minutes:seconds without having them change automatically to
hours:minutes.
tc
Anthony Chilco wrote:
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]
------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Thanks. Anthony, that's an interesting way of dealing with the problem.
I couldn't work out how to get the basic functions into the input line
though. It just ended up with text when I tried it.
--
--
With best regards, Derek Carr,
Birmingham, UK
http://alldruid.co.uk/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
