How to group time values by the hour?

[tomato632]

Hi all,

I have a list of data with distinct times, ie 7:02, 7:03, 7:05. How do I group these time values into by the hour to use for my KPI measure? (Please see attached)

Thanks!

[JGMDataAnalysis]

Timestamp(Floor(YourTime, (1/24)), 'hh:mm') AS RoundedTime;