How do I convert decimal values to hours & minutes in Excel 20
=CEILING(A1/24,1/96)
"Bo0ts" wrote:
Cool! Works well... Now, how do I roundup to nearest quarter hour?
Regards,
Bo0ts
"Peo Sjoblom" wrote:
Divide by 24
=A1/24
format as time and you'll get 04:52:48
if you really want 04:53 you would need to round, but then you need to
decide what rounding to use, nearest quarter hour, nearest half hour etc
--
Regards,
Peo Sjoblom
"Bo0ts" wrote in message
...
For example if I have, say, the value 4.88 in a cell I want to convert it
to
4h 53'
|