Formula to count number of patients within certain timeframes

[jedi4life]

Hello Excel gurus!

I need help figuring out a formula to calculate thenumber of patients existing within certain timeframes. Our goal is to determine how many nurses weshould schedule during 3 shifts: NOC (graveyard), AM, and PM. Any ideas? I’ve been pulling my hair out on this one.


Failed image code removed

 

[Michael M]

Can you try reposting the image please ?

 

[jedi4life]

Sorry everyone. I didn't know the image would appear like that. I'm still new to this.

Assume Col 1 is A, Col 2 is B.

4/3/19 2:22	4/4/19 20:21
4/3/19 4:54	4/4/19 14:07
4/3/19 11:05	4/4/19 13:16
4/3/19 12:50	4/3/19 21:14
4/3/19 13:08	4/4/19 12:52
4/3/19 16:35	4/4/19 16:10
4/3/19 17:30	4/4/19 16:10
4/3/19 19:40	4/4/19 18:21
4/4/19 0:25	4/4/19 21:34
4/4/19 0:35	4/5/19 19:18
4/4/19 2:15	4/5/19 14:27
4/4/19 8:33	4/4/19 19:26
4/4/19 12:50	4/5/19 21:03
4/4/19 13:50	4/7/19 6:45
4/4/19 16:36	4/5/19 15:15
4/4/19 20:46	4/5/19 12:43
4/4/19 23:30	4/5/19 16:01
4/4/19 23:36	4/5/19 20:44

<colgroup><col width="102" style="width: 76pt; mso-width-source: userset; mso-width-alt: 3612;" span="2"> <tbody> </tbody>

Shifts: Assume Col 1 is A, Col 2 is B, Col 3 is C

	From	To
NOC	23:00	7:00
AM	7:01	15:00
PM	15:01	22:59

<colgroup><col width="64" style="width: 48pt;"> <col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3413;" span="2"> <tbody>
</tbody>

 

[jedi4life]

Hello Michael, sorry about that. I reposted...

Sorry everyone. I didn't know the image would appear like that. I'm still new to this.

Assume Col 1 is A, Col 2 is B.

4/3/19 2:22	4/4/19 20:21
4/3/19 4:54	4/4/19 14:07
4/3/19 11:05	4/4/19 13:16
4/3/19 12:50	4/3/19 21:14
4/3/19 13:08	4/4/19 12:52
4/3/19 16:35	4/4/19 16:10
4/3/19 17:30	4/4/19 16:10
4/3/19 19:40	4/4/19 18:21
4/4/19 0:25	4/4/19 21:34
4/4/19 0:35	4/5/19 19:18
4/4/19 2:15	4/5/19 14:27
4/4/19 8:33	4/4/19 19:26
4/4/19 12:50	4/5/19 21:03
4/4/19 13:50	4/7/19 6:45
4/4/19 16:36	4/5/19 15:15
4/4/19 20:46	4/5/19 12:43
4/4/19 23:30	4/5/19 16:01
4/4/19 23:36	4/5/19 20:44

<tbody>
</tbody>

Shifts: Assume Col 1 is A, Col 2 is B, Col 3 is C

	From	To
NOC	23:00	7:00
AM	7:01	15:00
PM	15:01	22:59

<tbody>
</tbody>