Formula to calculate total duty hours

user_15797945 0
Viewed 128

How do I find the total working hours of the below driver?

Duty code    Dep.Time    Arri.Time
A001         03:35        04:20
A001         04:35        05:20
A001         05:51        06:20
A001         06:40        07:20
A001         09:40        10:20

Total Working Hour: 10:20-03:35 = 06:45hrs

Is there a formula to find the total working hours of a single person or a single duty card?

excel-formula vba excel
1 Answers

If you only have one Duty Code as in the example, you can use the MAX and MIN functions to calculate the total hours.

enter image description here

If you have more than one Duty Code, you can use MAXIFS and MINIFS.

enter image description here

user_38170680
Related