Dineshkumar
Reputation: 1548
How to convert String with GMT Values to Date in Excel?
I have a list of date values like, November 23, 2016 4:21:02 PM GMT-06:00. How to sort this in Excel? I would like to know the possible formula (or how to make one) to get the date out of it.
Upvotes: 1
Views: 1572
Answers (1)
Scott Craner
Reputation: 152585
use this formula:
=INT(--LEFT(A1,FIND("GMT",A1)-1))
Then format the date as you would like.
Upvotes: 2
Related Questions
- How to convert string to Date/Time in Excel?
- how to convert time zone of a datetime in google sheets
- Convert string date from UTC to AEST
- Text String to Date Time Conversion in Excel
- How to convert UTC to datetime in Excel
- Converting a string to a date in Excel
- Convert date-time string to Date in excel
- Excel: Need to retrieve Date in " yyyy/mm/dd hh:mm" format from string having date and time
- Extract date from the following string format
- Converting String to Date in Excel