Jul 24 2022 05:34 AM
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!
Jul 24 2022 05:46 AM
SolutionJul 24 2022 06:02 AM
Jul 24 2022 06:53 PM
Jul 24 2022 06:57 PM
Jul 24 2022 05:46 AM
Solution=COUNTIFS(E3:E9,">06:30:00",F3:F9,"<>Course")
Maybe this is what you are looking for.