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