G. Roderick Singleton wrote:
On Tue, 2005-11-01 at 12:03 +0000, 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.
Have you set the cell parameters for that time format? Should be mm:ss
Roderick, hi, that's part of the problem, setting to the right format:
MM:SS truncates the hours part, and interprets 45:36 as 45 hours - so
you just see 36:00 - which I think is a bug (but a bug that seems to
have been around since 123 for DOS, I wouldn't wonder!)
--
--
With best regards, Derek Carr,
Birmingham, UK
http://alldruid.co.uk/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
