techwriterAR
MIS
I have built a database that tracks work efficiencies. I collect the product number, date, quantity required, quantity produced, number in crew, start time, end time, set up time, and goal time. I have a forumla in a query that calculates the difference between start and end times. However I need to account for lunch breaks for first and second shifts. I can do this in excel by comparing the start time and end time to fixed references (absolute values for lunch start and end-11:30am to 12:00pm, and 9:30 pm to 10:00 pm). I have searched until I am blue in the face and have not been able to figure out how to do this in Access. Any help will be greatly appreciated.
Thanks,
gjeffcoat
Thanks,
gjeffcoat