Randomthots wrote:
[EMAIL PROTECTED] wrote:
I agree with the basic point that time formats aren't real easy to
use for many applications of it. But I have to say I had very
similar frustrations with Excel.
I often deal with timed results of sporting events where the times
range from around 20 minutes (with seconds) to 140 minutes. I'd love
to be able to just enter times as 35:16 or 76:45 etc., and have them
interpreted properly as minutes and seconds, but I can't figure out
how.
In a message dated 11/2/2005 7:30:10 PM Eastern Standard Time,
[EMAIL PROTECTED] writes:
Yes, as I just replied to Joe, I'm disappointed at this. Why on
earth would anyone want a MM:SS format then? Rhetorical question, I
suppose. Certainly I think it's a bug (in the help/documentation if
nowhere else) that the display format does not match the input format.
This may be a dumb question, but...
Since there are 60 minutes to an hour just like there are 60 seconds
to a minute, why not just use a format code of [HH]:MM and pretend the
minutes are hours and the seconds are minutes? You get the display the
way you want it and it would be trivial to adjust any calculations
where that would matter.
First, sorry for any confusion to Joe and Anthony replying as
[EMAIL PROTECTED] - that's my default account and I forgot to change
to this name.
Rod, that is a fantastic idea using [HH]:MM much easier. Next time I'll
use that (assuming it's fairly soon so I remember it :-)) many thanks.
--
--
With best regards, Derek Carr,
Birmingham, UK
http://alldruid.co.uk/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
