M
miroshak
I need create a formula that show how many patients were available to be seen
on each day of the month. I would like to make the cut-off for changes of
dates as 3pm, meaning that one day is from 3pm - 3pm the next day.
e.g. - 12/30/09 available patients would be all those there from 3:01pm on
12/29/09 to 3:00pm on 12/30/09.
If they're available for the full day count them only. Using this logic with
the data below on 12/30/09 only 2 patients were available to be seen.
Name Request DT Res DT
P1 12/27/2009 1:26 12/31/2009 16:28
P2 12/27/2009 12:00 12/30/2009 7:20
P3 12/23/2009 9:09 12/23/2009 9:12
P4 12/18/2009 10:25 12/18/2009 12:44
P5 12/29/2009 6:04 12/31/2009 9:20
P6 12/13/2009 15:37 12/13/2009 15:39
on each day of the month. I would like to make the cut-off for changes of
dates as 3pm, meaning that one day is from 3pm - 3pm the next day.
e.g. - 12/30/09 available patients would be all those there from 3:01pm on
12/29/09 to 3:00pm on 12/30/09.
If they're available for the full day count them only. Using this logic with
the data below on 12/30/09 only 2 patients were available to be seen.
Name Request DT Res DT
P1 12/27/2009 1:26 12/31/2009 16:28
P2 12/27/2009 12:00 12/30/2009 7:20
P3 12/23/2009 9:09 12/23/2009 9:12
P4 12/18/2009 10:25 12/18/2009 12:44
P5 12/29/2009 6:04 12/31/2009 9:20
P6 12/13/2009 15:37 12/13/2009 15:39