Calculating hours between two timestamps

[Bilingual]

Hi , i have a data set where my assignment is to create a graph which shows the number of timestamps for every hour during the day.
The resolution so far is to create a column for every hour for a day(example shown)and formulas which validates whether the time is within the singular timestamp .

So far its working, but as i need to use the results for the timestamps in a Pivot as a categories NOT values for every single one, it creates problems, has any a good idea out of the box?

[TABLE="width: 500"]
<tbody>[TR]
[TD]Start time[/TD]
[TD]End time [/TD]
[TD]Time stamp 0900[/TD]
[TD]Time stamp 1000[/TD]
[TD]Time stamp 1100[/TD]
[/TR]
[TR]
[TD]0800[/TD]
[TD]1600[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]2300[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

 

[PhilS2520]

Hey Bilingual,

I am not seeing what you want. From 0800 to 1600 there are 09, 10, 11, 12, 13, 14, 15, and 16 hours. But you only show the first 3. Is that an example of the worksheet?

And from 1000 to 2300 there are more hours, but 09 is not one of them?!

From 0800 to 1600, you have no value between 0800 and 0900, but in 1000 to 2300 you have a 1 for the 100 hour?

Every single one... what does one refer to?