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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top