Difference Between Time based off of a 10 Hour Workday

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.

Paste this code in to a macro module

Please Login or Register  to view this content.

Then enter this formula into cell H22

=WorkHours(F22:G22)

When I try to count the hours over a span of a few days, it doesn't give me a accurate total number of hours.. So if I started a project at 1/5/19 at 1:00PM and ended the project at 1/9/19 at 1:00PM it outputs zero.. Need it to count total difference in hours but no more then 10 hours per day increments..

1/5/19 at 1:00PM to 1/9/19 at 1:00PM = 342

Is this right?

O22 and custom format to [h]:mm

Formula:

Please Login or Register  to view this content.

Originally Posted by Sulprobil

Google for
[deleted]

Regards,
Bernd P

It is not acceptable to use a post to drive traffic to your own web site.