Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,665
- Office Version
- 365
- 2016
- Platform
- Windows
I am here hoping someone can help me with coding this particular task.
I have a service time, as a decimal, assigned to variable 't_min'. In my example , t_min = 0.72 (5:15 PM)
I have a staff schedule in workbook("wb"), worksheet("STAFF"). This object is assigned to variable ws_corestaff.
What I would like to do, is generate a list of values (crews) from column A in which the service time (t_min) falls within that crews shift (Start-Column D - End-Column E)
The list can start at H3 on worksheet ws_ws_core.
I will be be very appreciative of any help provided.
I have a service time, as a decimal, assigned to variable 't_min'. In my example , t_min = 0.72 (5:15 PM)
I have a staff schedule in workbook("wb"), worksheet("STAFF"). This object is assigned to variable ws_corestaff.
Excel 2010 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
3 | Staff Roster | ||||||
4 | CUE1 | 1 | Kelly | 0.291667 | 0.625 | ||
5 | CUE2 | X | Not Staffed | 0.291667 | 0.625 | ||
6 | CUL1 | 2 | Jen | 0.666667 | 1 | ||
7 | HPE1 | A | Morgan | 0.291667 | 0.625 | ||
8 | HPE2 | X | Not Staffed | 0.291667 | 0.625 | ||
9 | HPL1 | C | Tessa | 0.5625 | 0.895833 | ||
10 | HPL2 | X | Not Staffed | ||||
11 | RPE1 | A | Corey | 0.291667 | 0.625 | ||
12 | RPE2 | A | Jessica | 0.291667 | 0.625 | ||
13 | RPL1 | C | Ashley B. | 0.5625 | 0.895833 | ||
14 | RPL2 | X | Not Staffed | ||||
15 | WPE1 | A | Kiana | 0.291667 | 0.625 | ||
16 | WPE2 | C | Jeremy | 0.291667 | 0.625 | ||
17 | WPL1 | C | Lauren | 0.5625 | 0.895833 | ||
18 | WPL2 | X | Not Staffed | ||||
STAFF |
What I would like to do, is generate a list of values (crews) from column A in which the service time (t_min) falls within that crews shift (Start-Column D - End-Column E)
The list can start at H3 on worksheet ws_ws_core.
I will be be very appreciative of any help provided.