Thread: Trying to count number late/early for appoitment

I am trying to find a Countif formula that will count the number of appointments per visit type that are late by a buffer of more than 10 minutes and those that are early by a buffer of more than 10 minutes. Does anyone know how to do this?

A B C
Check-In Time Appoint Time Visit Type
7:34 7:30 1
7:39 7:30 3
7:40 9:30 2
8:13 8:15 2
8:39 8:45 1
8:55 9:15 2
9:46 10:00 3
10:31 10:45 3

LitsaK,

See attached. Note that column D is purely optional. Is something like that what you're looking for?

~tigeravatar