You know, that suggestion did cross my mind but I never got around to trying it. I just tried it and it does seem to work. The key is the brackets around the [HH]. That allows the hours to go past 24 without wrapping back to 00. Thanks for the suggestion. In a message dated 11/2/2005 10:29:09 PM Eastern Standard Time, [EMAIL PROTECTED] writes:
[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
