Timeline for converting time in excel and/or adding +12 hours
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 11, 2019 at 23:20 | vote | accept | HattrickNZ | ||
| Aug 7, 2019 at 3:07 | comment | added | HattrickNZ | tks but how do I do the conversion you speak of? | |
| Aug 6, 2019 at 23:49 | comment | added | teylyn |
Strictly speaking, the Z part in the date/time string means Zulu time, aka GMT. If you convert it to another time zone, it is no longer Z but GMT + 12
|
|
| Aug 6, 2019 at 22:27 | answer | added | Scott Craner | timeline score: 1 | |
| Aug 6, 2019 at 22:22 | history | asked | HattrickNZ | CC BY-SA 4.0 |