View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
barry houdini[_4_] barry houdini[_4_] is offline
external usenet poster
 
Posts: 57
Default convert work hours

On Dec 29, 6:06*pm, Carolina Girl
wrote:
Please help…. What is the formula to convert 1.0 days into 8.0 hours????
Thank you in advance


If you have the number of days in A1 then perhaps

=A1*8

to get 8......or if you want 8:00 in time format then use

=A1*8/24

format result cell to show as time, i.e [h]:mm