I am trying to convert the date/time CST field in excel to GMT
Example
------------
How to convert
01/30/2022 07:55 to 01/30/2022T01:55:00.000Z
This is being done before importing data to SF
Thank you!
5 respuestas
Greetings Shanthi,
Try This,
=TEXT(A1-(6/24), "MM/DD/YYYYTHH:MM:SS")
2022-01-30 7:55:00 -> 01/30/2022T01:55:00
Note that, A1 should be time format.
I never add ".000Z" value for date/time field update. But If you need that, try this,
=TEXT(B4-(6/24), "MM/DD/YYYYTHH:MM:SS")&".000Z"
it will return '01/30/2022T01:55:00.000Z'
Hope it works for you.
Thanks.