View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default How do I convert a time format to a double

Multiply with 24 and format as general


--

Regards,

Peo Sjoblom

"DMB" wrote in message
...
I use a function to calculate the hours worked based on time

12:00pm to 4:00pm is 4.0 hours

when I get the number for hours worked it is in time format / .27398237 I
need the number 4 so that I can do my calculation. How do I convert it to

a
number?