[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.
--
Rod
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
