Pls find the attached file and let me know if this is how you want it.
I have created a table called Hour which has all hours from 0 to 23, using autogenerate
0+recno() as EventHour
EventHour must be associated to the Hour(timestamp)
24hrrange.qvw 135.2 K