close
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?
Multiply with 24 and format as general--
Regards,
Peo Sjoblom
quot;DMBquot; gt; wrote in message
...
gt; I use a function to calculate the hours worked based on time
gt;
gt; 12:00pm to 4:00pm is 4.0 hours
gt;
gt; when I get the number for hours worked it is in time format / .27398237 I
gt; need the number 4 so that I can do my calculation. How do I convert it to
a
gt; number?
全站熱搜