Excel Tricks


UTC Conversions –

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)