SUMPRODUCT formula returning #NUM! error message

I'm sorry for being a huge nightmare.

I have two sheets running within the same workbook:

All Information

and

Data Breakdown


Now, in "All Information", Column B:B is "Ethnicity" and Column G:G is length of time of wait for interview.

So, I am wanting to find the number of occurences each ethnicity has waited under 6hrs, over 6hrs and over 12hrs. The timing of interviews are formatted to hh"hrs",mm"mins" so for example 1 hour 23 minutes would read as: "1hr,23mins" (I'm not sure if this makes a difference)

My first formula I'm trying to do this for under 6hrs is:

=SUMPRODUCT(('All Information'!G:G="<06hrs,00mins")*('All Information'!B:B="White"))



I've also tried formatting the cells as [h]:mm using this formula:

=SUMPRODUCT(('All Information'!G:G="<6:00")*('All Information'!B:B="White"))


Both present back #NUM

Can anybody offer guidance where I'm going wrong?

Thank you.

you cant use whole column references pre excel 2007 shorten it a bit to

=SUMPRODUCT(('all information'!G1:G1000<=VALUE("06:00"))*('all information'!B1:B1000="White"))

try
=SUMPRODUCT(('all information'!G1:G1000<=VALUE("06:00"))*('all information'!B1:B1000="White"))