I need help to calculate the utilization of a room by time of day with MS Excel.
For instance, an individual uses a room from 8:15 - 17:30. How do I take this date range and show the utilization in one hour intervals from 00:00 to 23:00:
7:00-8:00 - 0 min
8:00-9:00 - 45 min
9:00-10:00 - 60 min
17:00-18:00 - 30 min
I need to perform this caclutation on hundreds of rooms with an automated formula or code.