Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how many people are scheduled between...
i am using a schedule template from excel templates.
Column A: Name Column B: Start Time (Sunday) Column C: End Time (Sunday) Column D: Start Time (Monday).... Row 3: Emp 1 Row 4: Emp 2 Row 5: Emp 3... i enter staff hours for Sunday: Emp 1 - Start 10:00, End 17:00 Emp 2 - Start 10:00, End 12:00 Emp 3 - Start 11:00, End 14:00 in Cell A1, i want to know how many people are scheduled between 10 and 11 AM. 2 is the answer, but is there are way to create a formula for this. i would need to do this for the entire weekly schedule (7 days, time frame of 7am to 9pm - hourly). thank you, jat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel macro's to run at a scheduled time | Excel Discussion (Misc queries) | |||
scheduled back up | Excel Discussion (Misc queries) | |||
scheduled project in a calendar | Excel Discussion (Misc queries) | |||
scheduled hours total | Excel Discussion (Misc queries) | |||
scheduled hours total | Excel Worksheet Functions |