tinydancer
New Member
- Joined
- Jun 15, 2016
- Messages
- 44
I am trying to build an hour by hour scheduling template that is interactive based on the start time, end time, lunch time and count inputs. I have attached a picture below illustrating what I would like the final results to look like. Essentially, I want to be able to input the shift start time, end time, lunch break and count and I want a row of numbers to auto fill along the template to populate the number of FTE's I'll have working that particular hour.
For example:
If somebody works 8 to 5 with a lunch break at 12. I want the number 1 to populate in each column from 8 through 4 (16) o'clock with the 12 hour populating a 0.5 to compensate for the 30 minute lunch break (assuming all lunches are 30 minutes). This can also be multiplied or divided depending on the count loaded. Same example as above let's say 2 people work that exact shift, then I would want the same cells to populate with the number 2 instead of 1 with the 12 hour being a 1 instead of 0.5. I am not really sure where/how to get started on building something like this. I'm assuming a macro will need to be built for these cells to handle multiple inputs. Any and all help appreciated, thank you.
For example:
If somebody works 8 to 5 with a lunch break at 12. I want the number 1 to populate in each column from 8 through 4 (16) o'clock with the 12 hour populating a 0.5 to compensate for the 30 minute lunch break (assuming all lunches are 30 minutes). This can also be multiplied or divided depending on the count loaded. Same example as above let's say 2 people work that exact shift, then I would want the same cells to populate with the number 2 instead of 1 with the 12 hour being a 1 instead of 0.5. I am not really sure where/how to get started on building something like this. I'm assuming a macro will need to be built for these cells to handle multiple inputs. Any and all help appreciated, thank you.