Information required

3 columns up to 30 jobs numbered in column “A”
If job 1 takes 40 min to complete then auto add 40 min to 6:30 start time..
If job 2 takes 20 min then auto add 20 min to job 1 end time,
If job 3 takes 20 min then auto add 20 min to job 2 end time etc.
Is the possible?

Job order    Time    Min add
    6:30   
1    7:10    40
3    7:50    20
2    7:30    20
4    8:30    40
6    9:00    20
5    8:40    10

By: James

Leave a Reply

Your email address will not be published. Required fields are marked *