How do I convert a time format to a double
 

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?

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?