Forum Discussion
Solved
EXCEL FORMULA
Could anyone help me to find the total working hours of the below driver in excel? DUTY CODE ROUTE PATTEN DEP: TIME ARI: TIME A001 GD10 IN 3:35 4:20 A001 GD10 IN 4:35 5:20 ...
I think this will work as long as the driving time is less than 24 hours. I will play with this, but if the drive times are short, this may work. If I have misunderstood the request, please let me know, and I'll see if I can improve this. Good luck!
| DUTY CODE | ROUTE | PATTEN | DEP: TIME | ARI: TIME | Minutes Depart | Minutes Arrive | Drive Time in Minutes | In Hours |
| A001 | GD10 | IN | 3:35 | 4:20 | 215 | 260 | 45 | 0.75 |
| A001 | GD10 | IN | 4:35 | 5:20 | 275 | 320 | 45 | 0.75 |
| A001 | GD21 | IN | 5:51 | 6:20 | 351 | 380 | 29 | 0.48 |
| A001 | GD10 | OUT | 6:40 | 7:20 | 400 | 440 | 40 | 0.67 |
| A001 | GD09 | OUT | 9:40 | 10:20 | 580 | 620 | 40 | 0.67 |
- In the sheet you are not calculating brake time
First trip starts at 3:35 and finished at 4:20
After that next trip starts at 04:35 , between 4:20 to 4:35 few minutes gap(rest time) is there. Each duty having same
In your calculation brake time (gap or rest time) not considered
Above duty is only for one driver i just want to know how do i calculate multiple drivers duty hours in a single formulaDear Philip thanks for your support it's very useful.
