Time Format

[JPCFSP]

How to format time that exceeds 24 hours to reflect an accurate number (example - 25 hours shows as 1 hour - need it to show 25 hours).

Thank you.

[#2 · Accepted solution]

@JPCFSP 

Apply the custom number format

[h]:mm

or, if you need seconds too

[h]:mm:ss

[#3]

@JPCFSP Excel understands days as numbers, and so hours of a day a fractions of 1. To that end, I set out the example below:

Divide 25 by 24 hours = 1.04 = 25:00, with custom number formatting [h]:mm

I hope that helps.

[#4]

@KallunWillock 

Thank you. I might try that. I heard from Hans, and his recommendation worked like a charm.

[#5]

Thank you. This worked really well!!

[#6]

@Hans Vogelaar This worked really well. Thank you so much.