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 ...
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 formula
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 formula
Dear Philip thanks for your support it's very useful.