Convert Hours To Decimal Formula Employee Time ing s Minutes Homebase
The easiest way to convert time to decimal in excel is to times the original value by the number of hours, seconds or minutes in a day. For seconds, divide the cell by 86400 (24 x 60 x 60), in cell g3