Basics of Spreadsheet & Formatting. Tab name = HFC
-------------B--------------------------C------------------------------- D---------------------- F-----------------------Column
1--------- Day----------------------- Date ----------------------------Time ------------------Source---------------------Row
2 |=TEXT(C2,"dddd")|----------MM/DD/YYYY HH:MM:SS|----------=TEXT(C2,"HH:MM")|---------Text-----------------------Cell Formats
3-------Saturday---------------3/1/2013 12:16:37 AM-----------------00:16-------------------Outage---------------------Data

On a separate tab the goal is to get the number of calls "Outage" generated on a specific day, during a specific hour hour.

This part of the query works:
=COUNTIFS(HFC!F:F,"Outage",HFC!B:B,A311) gets me all outages on Saturday

When I add time to the Query it returns a 0:
=COUNTIFS(HFC!F:F,"Outage",HFC!B:B,A311,HFC!D:D,"& Time>=0,0,0",HFC!D:D,"&Time<1,0,0")



I have tried replacing time values 0,0,0 & 1,0,0 with 00:00 & 01:00 with the same results.

Also tried pasting the Date/Time Data to all 3 cells and formatting each cell to display only the needed data. That countif didn't work at all.

I can't figure out where I am going wrong in the query or if there is a way to get the data to display as a number instead of text.
Appreciate any help I can get