Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif time is between two nominated times
I have a list of clients and the time they were seen. I need to count how
many clients where seen between set time eg how many were seen between 12:00:00am adn 04:00:00am Please help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif time is between two nominated times
I assume you mean between 12 (midday) and 4 (pm):
=SUMPRODUCT(--($A$1:$A$20=(12/24)),--($A$1:$A$20<=(16/24))) If you mean between 12 (midnight) and 4 (am) ! then =SUMPRODUCT(--($A$1:$A$20<=(4/24))) HTH "hopeless in excel" wrote: I have a list of clients and the time they were seen. I need to count how many clients where seen between set time eg how many were seen between 12:00:00am adn 04:00:00am Please help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif time is between two nominated times
Thanks for your guidance Toppers, it seems to have worked. As I need to now
calculate the number of clients that come with each 4 hr block over 24 hour period that is how many between 12mn -4am, 4am -8am, 8am-12md, 12md-4pm, 4pm-8pm and 8pm-12mn. Can I just substitute the times into the formula? I did try it and it seemed to miss a couple in each time slot "Toppers" wrote: I assume you mean between 12 (midday) and 4 (pm): =SUMPRODUCT(--($A$1:$A$20=(12/24)),--($A$1:$A$20<=(16/24))) If you mean between 12 (midnight) and 4 (am) ! then =SUMPRODUCT(--($A$1:$A$20<=(4/24))) HTH "hopeless in excel" wrote: I have a list of clients and the time they were seen. I need to count how many clients where seen between set time eg how many were seen between 12:00:00am adn 04:00:00am Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Countif to count occurences of time? | Excel Worksheet Functions | |||
Entering Times | Excel Discussion (Misc queries) | |||
Adding time | Excel Discussion (Misc queries) | |||
Formula to calculate elapsed time between certain dates and times | Excel Discussion (Misc queries) | |||
Time Sheets | Excel Discussion (Misc queries) |