Forum Discussion
Number to hours
Hi, I've performed an operation on a column which gives me a number, and I'd like to transform this number into hours. How do I do this? I've used “cell format” but it doesn't work. Example: m...
4.5 hours corresponds to 4:30, not to 4:50.
Let's say your total is in D2.
Excel stores times as fractions of 1 day = 24 hours, so to convert a number of hours to time, divide by 24.
In another cell, enter the formula =D2/2/24
Apply the custom number format [h]:mm to the cell with the formula.
This can be filled down if required.