Im using Excel 2013 Ive been able to 1 Add some conditional formatting to highlight errors in the data set on the Data sheet. In other words 609 of the stays are 244 days or less. A patient admitted 10 minutes before midnight will have a length of stay that is 1-day longer than a patient who is admitted at 10 minutes after midnight even if they are discharged at exactly the same time and day.
Total length of stay Total number of reservation 30 4 75 days This is how the formula for average length of stay works.
A patient admitted 10 minutes before midnight will have a length of stay that is 1-day longer than a patient who is admitted at 10 minutes after midnight even if they are discharged at exactly the same time and day. We compare these methods and make recommendations on when each is most appropriate. 2 Figure out how many were referred to admitted and discharged from the program on a given month. Average Length of Stay is calculated by summing the number of days for all stays where partial days including non-overnight stays are rounded up to the next full day and dividing by the number of patients.