Column B is date/time = 07/02/2016 04:00:00
I am only interested in the time so i am using this formula =SUMPRODUCT(--(HOUR(B10:B290)=4)) to count the times that = 04:00.
What I need is a formula that will only count the times that =04:00 if the text in column F10:F290 = Start
I hope this makes sense..
I am only interested in the time so i am using this formula =SUMPRODUCT(--(HOUR(B10:B290)=4)) to count the times that = 04:00.
What I need is a formula that will only count the times that =04:00 if the text in column F10:F290 = Start
I hope this makes sense..