Creating Time Schedule in Excel

D

dmitry

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!
 
F

Fred Smith

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
 
Top