View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Creating Time Schedule in Excel

If your duration is actually in mm format, it's simple addition, as in:
a1=start time, a2 = duration
a3=a1+a2

If your duration is actually in number of minutes, then use:
a3=a1+a2/1440

Regards,
Fred


"dmitry" wrote in message
...
Hi!
I'm having proplems with creating schedule:
1st task Start time - (will be given in HH:MM format)
1st task Duration - (will be given in MM format)
1st task Finish time - (need to find in HH:MM format)

2nd task Start time = 1st task Finish time
2nd task Duration - (will be given in MM format)
2nd task Finish time - (need to find in HH:MM format)

etc.
I really appreciate any help!