Section 18 Working Hours Between Two Dates

Manufacturing Corner on

Sunday, November 20, 2022

 Working Hours Between Two Dates (Calendar Formula 2)

The more observant of you may have noticed a problem with the last two Gantt charts. They are fine as long as the start of the first job coincides with beginning of the day, but if you go to Section 16 and change the start time to, say 10:00 AM, then there are still 9 hours used on the first day, that can't be right. If the first job starts at 10:00 AM, then the Start Hr of job A should be 2, the 2nd hour of the schedule. However, if the first job starts at 2:00 PM, then that is 5.25 hours into the schedule because according to Calendar 2 there is a 15 minute morning break and a 30 min lunch break in between.

What we need is a formula that takes two points in time and calculates how many working hours (days x 24) there are between the two points. The calculation is very similar to that in Section 6:

The first 9 stages of the calculation locate the start on the calendar, and they are repeated for the stop:

Labels: Scheduling Excel Basic

Thanks for reading Section 18 Working Hours Between Two Dates. Please share...!