How do i format time in decimal to hh:mm:ss

[arciealba]

Hi,

I have here 89.56 hours and would like it to be in this format which is 89:33:00. Many thanks in advance! =)

[sweep]

Hi,

Excel measures time in increments of days, so if you enter 89.56 in a cell, it will be understood to be 89.56 days. To convert to hours, divide by 24 and the format, custom format [h]:mm:ss