How to convert time zone in excel?

C

Capitollium2021-09-12 08:30:15

excel

Capitollium, 2021-09-12 08:30:15

Hello!
How to convert time from Chinese time zone to Ukrainian.
Time in China is 5 hours ahead of time in Ukraine. What formula to use?

Here is the Chinese time format in excel:

spoiler

Start Date End Date
2021-09-12 01:57:15 2021-09-12 02:03:55
2021-09-12 01:46:58 2021-09-12 01:55:32
2021-09-12 01:36:21 2021-09-12 01:44:49
2021-09-12 01:21:24 2021-09-12 01:29:53
2021-09-12 01:14:32 2021-09-12 01:19:28
2021-09-12 01:03:58 2021-09-12 01:11:29

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

H

hint000, 2021-09-12
@hint000

https://www.google.com/search?q=excel+timezone+convert
first link from google search results:
https://www.extendoffice.com/documents/excel/3609-...
And yes, it works, I checked: