Target time = [Unix timestamp/1000 + (Target time zone) x 3600]/86400 + 70 x 365 + 19
To convert a Unix timestamp of 1475918112000 to Shanghai time (UTC+8), using the formula from step b:
Target time = [1475918112000/1000 + (+8) x 3600]/86400 + 70 x 365 + 19
Set the cell format to date and select a presentation format such as 2016/3/14 13:30. Then, the target time obtained will be presented as 2016/10/8 17:15.