Count a time a call is made

[gmazza76]

Good Afternoon

I have a spreadsheet with 2 tabs on "Calls Inbound" where the data is stored and "Calls Inbound Overview" where I have an overview.

I am trying to count how many times a call is taken between set times and I am having no look.

The date ("A") and time ("B") are in "Calls Inbound", but I am having trouble trying to get a countif to work. D18 is the time from and E18 is the time to. In the formula below I am trying to see how many calls were entered onto my spreadsheet between 08:00 - 09:00 so on an hourly rate. I will include the date at a later time, but I cant get it to count anything.

My time format is set as 00:00:00

=COUNTIFS('Calls Inbound'!A2:A42,">="&D18,'Calls Inbound'!A2:A42,"<"&E18)

Any help appreciated
Thanks in advance

 

[onlyadrafter]

Hello,

Alternative formula:

=SUMPRODUCT(--('Calls Inbound'!$A$2:$A$42=C18),--('Calls Inbound'!$B$2:$B$42>=D18),--('Calls Inbound'!$B$2:$B$42 < E18))

If you continue with dates and times in rows 19 onwards, just copy the formula down.

For just times try

=SUMPRODUCT(--('Calls Inbound'!$B$2:$B$42>=D18),--('Calls Inbound'!$B$2:$B$42 < E18))

(You will need to remove the spaces

I tried =COUNTIFS('Calls Inbound'!$B$2:$B$42,">="&D18,'Calls Inbound'!$B$2:$B$42,"<"&E18) and got the same result, so it may be something to do with your cell formatting.

Actually, your formula is looking at the dates column, isn't it?

 

[gmazza76]

What format on the time should I be using?
Thanks for the reply