Time Format: Probably Easier Than I Think

[cmcasper]

I'm entering my CD collection into an excel spreadsheet, and some albums are less than an hour, and some are longer than an hour. Obviously, for the ones less than an hour I have them formatted to look like 53:45. But, when I enter the ones longer than an hour, I'd like them to be displayed as 68:32 instead of 1:08:32. How do I format this?

[loginjmor]

Hi -

Try this custom format

[h]:mm:ss

Hope that helps

[cmcasper]

Thanks, but that one still gives me 1:08:32

[loginjmor]

Sorry -

Try this instead (my bad):

[mm]:ss

If you are still having problems, enter the data as 0:68:32 That should do it.

[cmcasper]

Thanks loginjmor! Just what I was looking for.