Hello -
I am struggling with a formula and am hoping someone can provide some suggestions on how to accomplish what I need. In the month of March, I have 19 available working days (M-F only). With 8 hours a day, that gives me 152 hours available in the month. My shift starts at 6:00 and ends at 14:00. I have 13 jobs that need to be started in the month of March, beginning March 4th. I can only start these on a Monday through Friday. The approximate time between each job is 11.69 hours.
I need to produce a list of dates to show what days I will be starting the jobs. Does anyone have suggestions on how I can best do this?
Thank you in advance!
I am struggling with a formula and am hoping someone can provide some suggestions on how to accomplish what I need. In the month of March, I have 19 available working days (M-F only). With 8 hours a day, that gives me 152 hours available in the month. My shift starts at 6:00 and ends at 14:00. I have 13 jobs that need to be started in the month of March, beginning March 4th. I can only start these on a Monday through Friday. The approximate time between each job is 11.69 hours.
Working Days | 19 |
Working Hours | 152 |
Start of Day | 6:00 |
End of Day | 14:00 |
Starts | 13 |
Hours between starts | 11.69 |
Starting Date | 3/4/2024 |
I need to produce a list of dates to show what days I will be starting the jobs. Does anyone have suggestions on how I can best do this?
Thank you in advance!