To change the decimals into hours, you first divide the number by 24hrs in excel then select number format, then custom then type h:mm
I've done the first two lines on the excel attached.
Also you can use this link to check:
Modified on: Wed, 22 May, 2024 at 2:24 PM
Did you find it helpful? Yes No
Send feedback