Limited elapsed time study

[Glenn_H]

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(C5>L5,L5+1-C5,L5-C5))),60*(24*(IF(B5>L5,L5+1-B5,L5-B5))))

But it gives me 76.00.


Any help is appreciated.


Glenn_H

 

[Glenn_H]

Finally came up with this.

=IF(AND(M5="Yes",C5<=(B5-0.0104)),(60*(24*(IF(B5>L5,L5+1-B5,L5-B5)))+15),(60*(24*(IF(C5>L5,L5+1-C5,L5-C5)))))

If anyone has an easier way please reply.

Glenn_H