0
I have this time in excel 2019-08-04T06:48:45.000Z
It is in GMT time, how do I convert it to +12 hours? So what I want is 2019-08-04T18:48:45.000Z.
That's an easier one(just have to change the hour) but I want to change the date too as will be required.
E.G This:
2019-08-04T22:35:15.000Z
To This:
2019-08-05T10:35:15.000Z
So far I can convert the hh:mm:ss.sss part of the string 2019-08-04T06:48:45.000Z
to decimal value 0.28
and then reformat that and it gives me 6:48:45 a.m.
I still have to add 12 hours to this, I am thinking I will convert 12 hours to decimal and then add this. But how would I go about adding to the date/day part of the string?
possible related questions which I will look into:
Converting time from text to hours and minutes in Excel
24-hours time with 12-hour notation
Converting time string text to hours and minutes in Excel
dropbox file columns N:AJ are of Interest
Strictly speaking, the
Z
part in the date/time string meansZulu time
, aka GMT. If you convert it to another time zone, it is no longerZ
butGMT + 12
– teylyn – 2019-08-06T23:49:48.547tks but how do I do the conversion you speak of? – HattrickNZ – 2019-08-07T03:07:25.023