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?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()