Forum Discussion
Hours to desimal
Hi! How can I change hours to decimal. For example 23073:06 hours to decimal?
Let's say you have a time in A1, with the custom format [h]:mm.
In another cell, enter the formula =24*A1 and set the number format of the cell with the formula to General or to Number.
Thanks Hans!
It works when your time number is under 10000:00:00 but when your time number is over 10000:00:00 it won't work.
