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.
Solved! Go to Solution.
Hi @luo,
The magical formula that will help you is:
Left([DateTime], 13)+':00:00'
Please see the workflow below: