saconroy66
New Member
- Joined
- Feb 27, 2018
- Messages
- 3
In my schedule I show the start and end times for my employees (see below). On a separate sheet I need to know how many people are working for every 30 minutes. For example, from 9am to 9:30am I can manually count that there is only one person working. From 9:30am to10am there will be two people working. And so on for the remainder of the day. With a large crew it takes too long to manually count this. Is there a formula that will calculate this for me?
<tbody>
</tbody>
Ashton | 10:00am | 2:30pm |
Brenna | 5:30pm | 9:30pm |
Caitlin | 5:00pm | 9:30pm |
Cassandra | 9:00am | 5:00pm |
<tbody>
</tbody>