Hello. I am trying to figure this out. I work at a hospital, and I want to know at any given time, how many people are in the waiting room. I have got all the statistic that will be plug in. It will be more then one day. As I change the date and time, so will the number of people waiting. In this example. At 18:30, 4 people are waiting, but you can see 2 people after the first one came in and was helped . I was thinking of COUNTIF function, but I am not sure.
<tbody>
</tbody>
Thanks for your help
This space are patient name | 01/04/15 | 14:44 | 14:50 | date | 01/04/15 |
01/04/15 | 14:48 | 14:56 | time | 18:30 | |
01/04/15 | 15:39 | 15:50 | how many people are waitng | ||
01/04/15 | 16:25 | 19:34 | |||
01/04/15 | 17:51 | 17:59 | |||
01/04/15 | 17:57 | 18:06 | |||
01/04/15 | 18:18 | 18:43 | |||
01/04/15 | 18:19 | 18:43 | |||
01/04/15 | 18:21 | 18:52 | |||
01/04/15 | 20:02 | 20:13 | |||
01/04/15 | 20:09 | 20:30 | |||
01/04/15 | 20:18 | 20:21 | |||
01/04/15 | 21:21 | 21:27 | |||
01/04/15 | 21:37 | 21:38 | |||
01/04/15 | 22:02 | 22:09 |
<tbody>
</tbody>
Thanks for your help