View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Olle Humble Olle Humble is offline
external usenet poster
 
Posts: 1
Default 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