If Column/row C2 has the UTC Date and Time (01/01/2020 2:30:50) then Column D can be converted with =C2-5/24 (where 5 is your difference from UTC. Keep in mind DST and time zone will impact this)
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OkNo
You can revoke your consent any time using the Revoke consent button.Revoke consent