Checking time values in a column.

[Big.Moe]

I have a column with a bunch of times in the "10:00 AM" format. In the next column I have corresponding sales for that time. I need to sum all the sales for each time period (i.e. 10:00 AM, 10:30 AM, 11:00 AM, etc.)

In a similar example, I used this formula with MONTH, but I can't figure out what to use for time values:
=SUM(IF(MONTH($C$5:$C$4244)=11,$I$5:$I$4244))

Thanks in advance.

[GC Excel]

Hello,

You can probably use the HOUR() fonction.

Also, please note that in Excel, each day has a value of 1
one day = 1.0
one hour = 1/24
one minute = 1/24/60

So 10:00 AM = 10/24

If it doesn't help, please post a sample file.

[Big.Moe]

Ah, got it!

Here's the formula I got to work:
=SUM(IF($X$5:$X$4244=TIME(10,0,0),$Y$5:$Y$4244))

I guess I just didn't have the "TIME(10,0,0)" syntax correct.

[GC Excel]

Maybe also :

=SUM(IF(HOUR($X$5:$X$4244)=10,$Y$5:$Y$4244))

(not tested)