Hello,
I currently track products that go through our plant with a start time and a end time.. I am trying to have a function that takes the difference between 2 dates and times to tell me how long a item took to get through the plant and outputs the total hours.. But I don't want to track all hours in the day.. Only our work shifts..
Our shifts work 6AM to 4:30PM. We have a 30 minute break from 9:00AM to 9:30AM and another at 12:00PM to 12:30PM
I want to be able to see the difference in time and the total hours it took to build it and output it without counting all the hours in the day, only counting work hours.
Bookmarks