Hello, I am trying to count the number of employees scheduled/staffed in every 30 minutes interval. The data I want to count is formatted as 7:00 - 16:00, 8:00 - 17:00, 9:00 - 18:00, so on and so forth. Is there any way that you can help me with the right formula for this? The Time Interval is in Column A while the Count is supposed to be in Column B. The data set is referenced from another sheet. Thank you so much!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Counting staff scheduled in every 30 minutes interval.
- Thread starter VhanLab
- Start date
awoohaw
Well-known Member
- Joined
- Mar 23, 2022
- Messages
- 4,714
- Office Version
- 365
- Platform
- Windows
- Web
Please help the forum help you and post a sanitized (for security) sample of your data and expected results using the xl2bb add in (link below).
It takes time for the forum to create your scenario, it is from text and misunderstandings can occur. In worst case please post as a table. An image or picture will not be of much use.
Thanks in advance, and best wishes.
It takes time for the forum to create your scenario, it is from text and misunderstandings can occur. In worst case please post as a table. An image or picture will not be of much use.
Thanks in advance, and best wishes.
Upvote
0
Similar threads
- Question
