Round up time to next hour

[Anonymous]

Hi,

I have a column with some date data, ex.:

21-05-2019 14:00:00

21-05-2019 14:03:43

21-05-2019 14:52:13

I want some clean timestamps like the one 14:00:00, so i want to round up the other ones, as soon as they have passed an hour, i want it to round up to the next hour, so my data will look like:

21-05-2019 14:00:00

21-05-2019 15:00:00

21-05-2019 15:00:00

Can anyone help?

[Anonymous · Accepted solution]

Hi @Anonymous ,

add a column with

Column = IF(SECOND(Table1[Timestamp]) = 0, Table1[Timestamp] , TIME(HOUR(Table1[Timestamp])+1, 0,0))

Best regards Timo