We are doing a time study on appointment cycle times.


I need to know to total appointment time, but if the patient arrives more
than 15 minutes early to only count the cycle time from the scheduled
appointment time + 15 minutes.

(Scheduled time) = B5
(Arrival time) = C5
(=15 min Early) = M5
(Min Early) = N5
(PT Discharge) = L5


So
if B5 = 14:00,
and C5 = 13:44
and L5 = 15:00

M5 Displays "Yes"
N5 Displays 16.00

I need the cycle time result to be 75.00


I also need the same formula to calculate if the patient is late.

This is what I have so far.
=IF(OR(N5<=15,C5<=B5),60*(24*(IF(C5L5,L5+1-C5,L5-C5))),60*(24*(IF(B5L5,L5+1-B5,L5-B5))))

But it gives me 76.00.


Any help is appreciated.


Glenn_H