This content has been marked as final. Show 6 replies
a company is open from 07:00 to 13:00 and trucks deliver goods only between these times
So there is a column Total Time spent, which is the total time a truck spent @ the company, even if it was closed.
The column Actual time spent must show the time that the truck spent @ the company between 07:00 and 13:00
Truck one, actual time spent should be 02:00 which is good,
Truck two, actual time spent should be 02:00 (09:00 minus 07:00 (open time))
Truck three, actual time should be 03:00 (10:00 minus 07:00 (open time))
Please see attached