garypea123
Board Regular
- Joined
- Mar 16, 2020
- Messages
- 221
- Office Version
- 365
- Platform
- Windows
Hi,
I am trying to write a formula in say D3 which will look at C3 time and then tell me how many agents were on in that time.
For example the result for D3 would be 4 and the result of D4 would 5.
I think maybe a match and count formula or something? Or maybe something more simple. Trying to get back into Excel again and mind is blank
I am trying to write a formula in say D3 which will look at C3 time and then tell me how many agents were on in that time.
For example the result for D3 would be 4 and the result of D4 would 5.
I think maybe a match and count formula or something? Or maybe something more simple. Trying to get back into Excel again and mind is blank