Hi,

I have data of check-in and check-out times in a hotel (date and time) and need to compile average census by hour of the day. E.g. at 1:00am the average census is 150 while at 1:00pm the average census is 80.

It is easy to create average check in times from this data, but what is difficult is factoring in the lengths of stay over multiple days.

Any ideas? I have been stumped for the last few hours and have not come up with any particularly solid ideas.