[jlu]

Can you paste code on how #2 was done?

[joneholland]

Time stamp % 24

[eis]

That does not get you hourly time slots.

You either want something like

    floor(timestamp / 3600)

or

    timestamp - timestamp % 3600

[jlu]

that's clever, thanks!