Which total? Per date, per driver, etc. And what is in Depart column?
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
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.
Thank you for the help.
Mike, you are welcome