S
Shoney
Hello,
I'm looking to find a macro that will:
Read start time ranges and days to work based on entries to an online form.
Let's say, for example:
Agent 1 wants to work an 8-hour scheudle (8.5 w/lunch) that starts between
8:00 AM and 10:00 AM and is willing to work any five contiguous days during a
Sun-Sat work week.
I would like the macro to identify every possilble shift outcome, days and
hours(start times on the half-hour, 8:00 AM, 8:30 AM, etc., days can be any 5
contiguous days)
Shift start time ranges, let's say, are 8:00 AM in cell A1 and 10:00 AM in
cell A2, so the shift can start at any time (including the times listed)
between those two times.
I would think that making adjustments for a 4-day (10hrs/day) per week shift
would be fairly simple at that point, but if I would need to do anything
special for that, please let me know.
Any help you can provide would be greatly appreciated.
Thank you for your time and attention.
I'm looking to find a macro that will:
Read start time ranges and days to work based on entries to an online form.
Let's say, for example:
Agent 1 wants to work an 8-hour scheudle (8.5 w/lunch) that starts between
8:00 AM and 10:00 AM and is willing to work any five contiguous days during a
Sun-Sat work week.
I would like the macro to identify every possilble shift outcome, days and
hours(start times on the half-hour, 8:00 AM, 8:30 AM, etc., days can be any 5
contiguous days)
Shift start time ranges, let's say, are 8:00 AM in cell A1 and 10:00 AM in
cell A2, so the shift can start at any time (including the times listed)
between those two times.
I would think that making adjustments for a 4-day (10hrs/day) per week shift
would be fairly simple at that point, but if I would need to do anything
special for that, please let me know.
Any help you can provide would be greatly appreciated.
Thank you for your time and attention.