Thread: SUMIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KAB KAB is offline
external usenet poster
 
Posts: 3
Default SUMIF

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