Convert Decimal To Total Hours And Minutes

less than 1 minute read

When converting a decimal to hours and minutes, ensure to use the correct Number Format.

[h]:mm:ss
Shows the total number of hours, even if the number of hours is 24 or more.

hh:mm:ss Effectively only shows the excess hours over and above complete multiples of 24. For example, 105 hours is 4×24, or 4 whole days, plus 9 more hours, so it just shows the 9.

Remember, this is only a display format – the underlying values are the same in both cases.

See the below tabled example.

Tags: date-time

Categories: formulas

Updated: September 26, 2018

Leave a Comment