Forum Discussion

sarunsaji31's avatar
sarunsaji31
Copper Contributor
May 02, 2021
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 ...
Formulas and Functions
  • philipmikheikin's avatar
    philipmikheikin
    May 02, 2021

    work time for each driver including brake time, with helper column

     

    sarunsaji31 

CPadget's avatar
CPadget
Copper Contributor
May 02, 2021
Please see above - Drive time calculation.xlsx
sarunsaji31's avatar
sarunsaji31
Copper Contributor
May 02, 2021

CPadget  Hi there thanks for your support, please refer to the attached work data.

 

Is that possible to calculate total working hours in a single formula?

 

Resources