Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limited elapsed time study
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limited elapsed time study
Finally came up with this.
=IF(AND(M5="Yes",C5<=(B5-0.0104)),(60*(24*(IF(B5L5,L5+1-B5,L5-B5)))+15),(60*(24*(IF(C5L5,L5+1-C5,L5-C5))))) If anyone has an easier way please reply. Glenn_H "Glenn_H" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time + motion study template | Excel Discussion (Misc queries) | |||
Elapsed time | Excel Discussion (Misc queries) | |||
How to create a time study chart | Charts and Charting in Excel | |||
elapsed time | Excel Worksheet Functions | |||
Elapsed time | Excel Discussion (Misc queries) |