Hello
I am trying to get the total of days in a range of cells where the start time is later than 06:30 but I need to exclude the time if there is "Course* in another range os cells. I am using this formula:
=COUNTIF(E3:E9,">06:30:00") -SUMPRODUCT(COUNTIF(F3:F9,"Course"))
It is working when I have time after 06:30, but it comes negative result if I have 06:30 time and Course happening at the same time. Not sure if that makes sense.
Please I really would appreciate any help! Thanks!
I am trying to get the total of days in a range of cells where the start time is later than 06:30 but I need to exclude the time if there is "Course* in another range os cells. I am using this formula:
=COUNTIF(E3:E9,">06:30:00") -SUMPRODUCT(COUNTIF(F3:F9,"Course"))
It is working when I have time after 06:30, but it comes negative result if I have 06:30 time and Course happening at the same time. Not sure if that makes sense.
Please I really would appreciate any help! Thanks!