May 01 2021 05:33 PM
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 |
A001 | GD21 | IN | 5:51 | 6:20 |
A001 | GD10 | OUT | 6:40 | 7:20 |
A001 | GD09 | OUT | 9:40 | 10:20 |
Total Working Hour = 10:20-03:35= 06:45hrs
Is there any formula in excel to find the total working hours of a single person or a single duty card?
May 01 2021 07:43 PM
I think this will work as long as the driving time is less than 24 hours. I will play with this, but if the drive times are short, this may work. If I have misunderstood the request, please let me know, and I'll see if I can improve this. Good luck!
DUTY CODE | ROUTE | PATTEN | DEP: TIME | ARI: TIME | Minutes Depart | Minutes Arrive | Drive Time in Minutes | In Hours |
A001 | GD10 | IN | 3:35 | 4:20 | 215 | 260 | 45 | 0.75 |
A001 | GD10 | IN | 4:35 | 5:20 | 275 | 320 | 45 | 0.75 |
A001 | GD21 | IN | 5:51 | 6:20 | 351 | 380 | 29 | 0.48 |
A001 | GD10 | OUT | 6:40 | 7:20 | 400 | 440 | 40 | 0.67 |
A001 | GD09 | OUT | 9:40 | 10:20 | 580 | 620 | 40 | 0.67 |
May 01 2021 07:58 PM - edited May 01 2021 08:06 PM
does anything from this picture works?
make sure format is applied correctly
May 01 2021 08:25 PM
@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?
May 01 2021 08:45 PM
May 01 2021 08:47 PM
May 01 2021 09:06 PM - edited May 01 2021 09:09 PM
SolutionMay 02 2021 01:18 AM
You will find a suggested solution in the attached file.
Next time you want to ask (which we also want) please read this link in advance,
Welcome to your Excel discussion space!
it will save you and everyone who wants to help a lot of time.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
May 02 2021 12:17 PM - edited May 02 2021 01:31 PM
Dear Philip thanks for your support it's very useful.
May 01 2021 09:06 PM - edited May 01 2021 09:09 PM
Solutionwork time for each driver including brake time, with helper column