Timrproblem

[Ola Sigurdh]

Hello all

In a worksheet I have 3 columns, in the first date in the second a number
that is showing which load it is and in the third start and end time for
that load. It can be up to 3 different loads per day and up to 10 to 15 for
every number in column B.

A B C
1 1 05:00
1 1 10:00
1 1
1 2 12:00
1 2 14:00
1 3 15:00
1 3 18:00
1 3
1 3

In another sheet I want to have the total time for for every day, in this
example it would be 10 hours. Anyone knows?

TIA

Ola

 

[icestationzbra]

in your example, column A has a date, column B has load. this is fine
in column C you mentioned that you have start and end times. in you
example you have 05:00 and 10:00 for rows 1 and 2. then you mentione
that the sum should be 10 hours as per your example. could no
understand that part. can you explain a little more in detail? it i
easy to do what you want to do, that is to find sort of a SUMPRODUCT
but to tailor it for your specific need, little more detail would help

 

[Ola Sigurdh]

Hello
I meant the sum for the whole day. The truck has been out for 3 times that
day and I want the grandtotal for that day.

 

[Alex Delamain]

If I understand correctly on day 1 load 1 leaves at 05:00 and returns a
10:00. It then leaves with load 2 at 1200 returning at 1400. Finally i
goes out at 1500 returning at 1800, making a total of 10 hours ou
during that day.

What happens if the lorry is out past midnight? Do you allocate all th
hours to the day it left or split them across the two days

 

[Ola Sigurdh]

Hello Alex
Yes I allocate them to the day the truck leaves

Tia

Ola