Excel Time Formatting Questiong

[MrBlahh]

Is there a way to format time where if I enter in something like 00:24:09 it will show up as 24:09 but if I enter in 03:10:10 it will show as 3:10:10. Basically I only want to show the hours if the hours is greater than 0?

Its used for keeping track of how long something takes and it looks sloppy if its under an hour especially since most records will be under an hour.

 

[MrBlahh]

bump anyone?

 

[WillyF1uhm1]

There is no way i can think of, to do that directly, i.e. while entering the times on a worksheet.
Unless you use some kind of userform that will check your entry and will format the cell accordingly ....