6 Replies Latest reply: Sep 2, 2013 3:01 AM by Janes Krige RSS

    Time issue

      Good day,


      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