occupancy
1 Topic
Hospital Occupancy by Month
Hi I am working with some hospital data and need to calculate the length of stay in hours. The issue I am having is that I need to calculate it for the month so if a stay starts in January and ends in March, I need to be able to calulate the total stay in hours for January only rather than the total stay in hours. The data looks like this; Date Table - standard date table from Enterprise DNA. Hospital Data - arrival date, departure date, total stay in hours, total stay in days. Can anyone help?Solved1.5KViews0likes5Comments