CODEWITHSUNDEEP
excelvbaexcel-formula
Sarun Saji
Sarun Saji

Reputation: 19

Formula to calculate total duty hours

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?

Upvotes: 2

Views: 360

Answers (1)

Nicholas Hunter
Nicholas Hunter

Reputation: 1845

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

Upvotes: 2

Related Questions