More than 24 hours
I try to use VBA code for calculation time:
If TimePerTask*NumberOfTask<23:59 then their is no problem. The problem
occurs when TimePerTask*NumberOfTask24:00. I have tried different ways, but
the answer is always the same. Ex:TimePerTask=1:00 * NumberOfTask=32 gives
the result 8:00. The 24 hours is not showed, in the editor I can see the
result 1989-12-31 08:00.
What to do? Thanks in advance.
Olle Humble
|