Use < instead of <=

--


Regards,


Peo Sjoblom

"Peo Sjoblom" wrote in message
...
=SUMIF(Range1,"<="&(1/48),Range2)

or


=SUMIF(F4:F10,"<="&(1/48),E4:E10)


or


=SUMIF(F4:F10,"<="&TIME(0,30,1),E4:E10)


depending on where the values are




--


Regards,


Peo Sjoblom

"KAB" wrote in message
...
My spreadsheet is as follows:

1/3/2005 7:15 AM 8:15 AM 1.00 0:30
8:45 AM 9:45 AM 1.00 0:15
10:00 AM 11:00 AM 1.00 0:00
11:00 AM 12:30 PM 1.50 0:15
12:45 PM 3:45 PM 3.00 0:30
4:15 PM 6:15 PM 2.00

I am attempting to total all time equal to or less than 0:30 in column E
into Column F. Thank you for your assistance...

-KAB