from your descriptions, i gather that you are looking to find the total number of calls between 8 AM to 10 AM, and 12 PM to 2 PM.

if that is the case, you can try to use this formula in the context of the file that you uploaded in post #8 above:

=SUM(INDEX(((MOD(A1:A10,1)>=TIMEVALUE("08:00:00"))*(MOD(A1:A10,1)<TIMEVALUE("10:00:00"))) + ((MOD(A1:A10,1)>=TIMEVALUE("12:00:00"))*(MOD(A1:A10,1)<TIMEVALUE("14:00:00"))),0))
1007