| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number of employees function
I need to create a function that tells me how many employees are on the
schedule at 7AM, 8AM, 9AM, 10AM, 11AM, 12PM, ...up to 8PM. My schedule has an in time and an out time in separate cells. Example: Employee1 IN: 10AM OUT: 4PM / Employee 2 IN: 9AM OUT: 5 pm / Employee 3: IN: 3PM OUT: 8PM ...The number of employees on the clock at 11AM in this example would be 2. I can't get Excel to do this. Any help would be appreciated. Brian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Taking a total number of employees that meet certain conditions | Excel Worksheet Functions | |||
| Counting The Number of Employees | Excel Discussion (Misc queries) | |||
| Employees | Excel Worksheet Functions | |||
| Number of employees working at given time | Excel Discussion (Misc queries) | |||
| Number of employees in the appropriate time column | Excel Worksheet Functions | |||
Threaded Mode
