Search code examples
excelexcel-formulatimezonedatetime-conversion

How To Quickly Convert UTC Time To Local Time in excel?

Is there an easy way to convert the UTC time in this format (2020.05.28 15:45) into local time? I have a really long list to do the conversion. For example, 2020.05.28 15:45 coverts into 2020.05.28 23:45; 2020.05.28 16:45 coverts into 2020.05.29 00:45. I don't know how to change the date in excel?

Solution

  • =SUBSTITUTE(A1,".","/")+1/3