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