View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jerry Jerry is offline
external usenet poster
 
Posts: 142
Default countif function

I have a 4 column spreadsheet. Col a = date, Col b = time in, Col c = time
out, Col d = minutes spent. I would like to count all the entries that fall
between the hrs of 8:00 AM and 8:59 AM IF there are entries in both column b
and c. If there are not entries in both col B and col C, I want to disregard
those items. Help would be appreciated.