View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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'