Forum Discussion
sarunsaji31
May 02, 2021Copper Contributor
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 ...
- May 02, 2021
philipmikheikin
May 02, 2021Brass Contributor
load your file to see how you have organized workers data
CPadget
May 02, 2021Copper Contributor
Please see above - Drive time calculation.xlsx
- sarunsaji31May 02, 2021Copper Contributor
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?
- philipmikheikinMay 02, 2021Brass Contributor
- philipmikheikinMay 02, 2021Brass Contributor
does anything from this picture works?
make sure format is applied correctly