Forum Discussion
Looking for a solution to calculate total time form a arrive column and a depart column
Driver Date Tractor Trailer Location Billable Stop Delivery BH Appt Arrive Depart Odometer Delivered Trays Trays Picked Up Lundy, Jeffrey 6/2/19 852360 36406 SOMERSET DC/DEPOT 1...
The depart was time but I guess when I pasted something went off. I need the total by employee. Each "trip" is separated by a blank line. I attached a picture.
I'm not sure there you'd like to have your totals. If in blank row after the trip,
that could be
=SUMPRODUCT(MOD($J$2:$J4-$I$2:$I4,1)*($A$2:$A4=$A4))
which is copy/pasted on the cell after each trip. It calculates total time for the current employee for all trips,if more than one, with cumulative effect. Cell id to be formatted as [hh]:mm. MOD() here to calculate overnight time.
Mike, you are welcome