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.