View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default Converting decimal time to standard time?

=A1/24

where A1 holds 7.25, format as hh:mm


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"mpendleton" wrote in message
. ..

I am working on a formula spreadsheet and can NOT figure out how to
convert time that would include hours to standard time. For instance
if someone worked 7.25 hours it is 7 hours and 15 minutes. which would
read 7:15. Can anyone help.


--
mpendleton