how to automatically group the datetime data into hours?

[luo]

I have a column of data that looks like below:

DateTime

2020-01-14 16:00:03

2020-01-14 16:00:03

2020-01-14 16:00:03

2020-01-14 16:00:03

2020-01-14 16:00:05

2020-01-14 16:00:05

2020-01-14 16:00:11

2020-01-14 16:00:13

2020-01-14 16:00:13

2020-01-14 16:00:14

2020-01-14 16:00:14

2020-01-14 16:00:14

2020-01-14 16:00:14

2020-01-14 16:00:14

2020-01-14 16:00:15

2020-01-14 16:00:15

2020-01-14 16:00:16

2020-01-14 16:00:16

2020-01-14 16:00:17

I have three month data and I want to group the data into one hour. Means I want to see how many records per hours. Is there a way to do this? Thank you guys.

[Emil_Kos · Accepted solution]

Hi @luo,

The magical formula that will help you is:

Left([DateTime], 13)+':00:00'

Please see the workflow below: