Hello all!
I've been pulling my hair out on an issue I am trying to solve in a workbook that I've designed to see how many workers are on the floor in a 24 hours period based on work schedules. One major issue is a 24 hour shift. I have 30 min intervals set up on the worksheet but can't seem to find how to count the number of employee past 23:59.
Example:
Monday
Shift 1 - 0700 - 1500 - 5 workers ................ on the chart, formula would count 5 workers in 30 minute intervals from 0700 - 1500. And so on.....
Shift 2 - 2000 - 0500 - 5 workers..... I can't figure out how to calucate 5 workers from 0000 - 0500 on 'Tuesday' morning.
I've attached a sample workbook if anyone would like to see. On the right, is the work schedule key, where you can input schedules and then based on the times, need it to plot on the ghant chart (if you want to call it that) of the number of workers during the period.
I appreciate any assistance!
Bookmarks