Create a new column that adds 1 hour to all rows in 'date' column

[pal95]

Hi, I have the following Date Column:

I want to get a new column where, for example, 3/24/2023 8:12:56 AM will turn into 3/24/2023 9:12:56 AM, is that possible? thank you

[manvishah17]

Hi @pal95 ,
You can create calculated column 
NewDateTime = [YourDateTimeColumn] + TIME(1, 0, 0) 

[PhilipTreacy · Accepted solution]

@pal95 

Use this

= [Date] + #duration(0, 1, 0 , 0)

regards

Phil