Hour of the day dimension

[#1]

I have a field called SessionClosedTime, which is in the format HH:MM:SS

How can I group these values into one hour ranges, so that I can display my data by hour?

[tresesco]

Create a field like:

Load

          Time(SessionClosedTime, 'hh') as Hour

Or,

Load

          Time(Time#(SessionClosedTime, 'hh:mm:ss'), 'hh') as Hour

[er_mohit]

interval(timesessionclosetimefield,'hh')