| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count how many staff are scheduled between...
i am using a template from office.excel for a schedule.
i want to know if it is possible to do the following: Column A: Employee Name Column B: Sunday Start Time Column C: Sunday End Time Column D: Monday Start Time.... Row 5: Emp 1 Row 6: Emp 2 Row 7: Emp 3... Emp 1, Sunday schduled 10:00 to 17:00 Emp 2, Sunday schduled 10:00 to 12:00 Emp 3, Sunday schduled 11:00 to 16:00... in cell A15, i want to know how many people are schduled on Sunday between 10:00 and 11:00 (formula would return 2 - because two people are schduled to be there between 10 and 11 AM); in A16, time frame would be 11AM to 12 PM and the value returned would be 2; can this be done in excel? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count scheduled staff between hours | Excel Worksheet Functions | |||
| how many people are scheduled between... | Excel Worksheet Functions | |||
| how do I set count the number of staff in a rota working per hour | Excel Discussion (Misc queries) | |||
| scheduled back up | Excel Discussion (Misc queries) | |||
| how many staff have 1 skill, how many staff have 2 skills, etc. | Excel Discussion (Misc queries) | |||
Threaded Mode
