Add one hour to date/time column

[webportal]

How to add one hour to column Value below?

This is my custom step:

No matter what the second argument of the function is, nothing happens....

[aggiebrown · Accepted solution]

hi @webportal 

it's best to add UTC Time Zone, and then use "DateTimeZone.SwitchZone" function of Power Query to swap to whichever time zone you want to use.

I used UTC and CEST as example. You can look up the time zones on this website (it also tells you the time difference which you will need to use to set up your parameter): https://www.timeanddate.com/worldclock/

Adding UTC Column would look like this:

From then on you need to create Parameter with however many hours the time difference will be and use the parameter to switch time zones like so:

Create another custom column to switch time zones using your required parameter and delete any columns you no longer need in the next step (UTC column for example)

End result looks like this:

[Ahmedx]

pls try this

DateTime.From(Number.From(Value) + Number.From(#time(1,0,0)))
-----------or-------------------
DateTime.From(Text.From(Value)&" "&Text.From(#time(1,0,0)))
------------or----------------
DateTime.From(Text.From(Value)&" "&Time.ToText(#time(1,0,0),"hh:mm:ss"))