Skip to main content

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 respostas
  1. 22 de mar. de 2022, 15:33

    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.