M
Meebers
We have a high number of patients that come in between 6 am and 6 pm and we
need to count the times that they sign in. i.e. Every patient that signs in
at 6 am thru 6:59am I want a total. 7am thru 7:59am I want a total....etc.
Data is generated daily on a seperate sheet that I have to count so was
looking for a "portable formula" that I can paste and get the time
breakouts. Expected results 6=23 7=34 8=61 etc. (meaning there were 23
patients between 6 am and 6:59) TIA
need to count the times that they sign in. i.e. Every patient that signs in
at 6 am thru 6:59am I want a total. 7am thru 7:59am I want a total....etc.
Data is generated daily on a seperate sheet that I have to count so was
looking for a "portable formula" that I can paste and get the time
breakouts. Expected results 6=23 7=34 8=61 etc. (meaning there were 23
patients between 6 am and 6:59) TIA