To convert these fractional values to decimal hours, just multiply by 24. For example .5 * 24 = 12 hours, .24 * 24 = 6 hours, etc.

Durations over 24 hours

To calculate and display time durations over 24 hours, you’ll want to use a custom time format like [h]:mm. Otherwise, the duration will “reset” every 24 hours, in the same way that a clock “resets” each day. More on custom number formats here. Author

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.