How do I convert decimal values to hours & minutes in Excel 2000?
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'
|