Hi

I have a countif formula that works out if an item was resolved in within a target time or not. If it was, it gives a 1 and if it wasn't it gives a 0.

The formula I have works fine except for when an item was resolved on the same date, but hours after the target time. IE at the moment if it was meant to be resolved at 12pm but was resolved at 1pm, it's still giving it a pass as the date is the same. I need to adjust the formula so it takes the time and not just the date into account.

I have this currently:

=IF(COUNTIFS('$G:$G,$B16,'$L:$L,"<="&U$11,$M:$M,">"&U$11)>0,0,1)

It is the bit in bold that is the bit that checks the dates against each other. Can I add something simple in so it takes the time into account?

Thanks