Creating Graphable Hourly Data

I need to graph the average, by hour, by day that a room is occupied.

I've attached my data to help give a visual, but I'll try and explain it anyway.

I'm working with ~2500 rows of data. Unfortunately, my data is presented in a manner where I have the InHour and OutHour for each row, but each stay is not broken down to the hours the room is occupied. For example, for the first row the InHour is 7 and the OutHour is 12 on a Friday. When I graph the data I need this stay to go to the Friday average for 1 hour at 7, 8, 9, 10, 11 and 12.

I'm not sure the quickest way to break this down, is it a calculated field in a PivotTable, or a formula I'm not aware of?

Thanks in advance for any help and, please, let me know if I can provide any more clarification.

Thanks for the response Ace.

I've attached a graphed example of my data. I extrapolated out the rows to the hours contained in the row. For instance the first data row has 7, 8, 9, 10, 11, and 12. This extrapolation is what I need the formula to accomplish. I then divided my count of the hours by how many weeks there were, in this case 4, to graph the average occupancy of the rooms by hour.

Please, let me know if I can clarify further or provide additional examples.

I'm worried my question may be too vague. I think the question comes down to how can I create an Hour column that adds a row for each hour elapsed? In the row is the addition of HourIn and an elapsed hour. If the elapsed hour is 3, I'd have 2 additional rows. If HourIn is 13, I'd have three rows, one with 13, 14, 15.

I've attached my solution. It's definitely not the most elegant, but it boils down to the Offset formula.