Google Sheets – How to Parse Date and Time in Specific Format

google sheetsgoogle-sheets-dates

I have a CSV file with dates in the following format:

2012-06-20T00:00:00+00:00

Is it possible to parse a date or date and time in this format? The goal is to turn it into a date and time that Google Spreadsheet understands.

The format is YYYY-MM-DDTHH:MM:SS.

Maybe:

=left(A1,10)+mid(A1,12,8)

There isn't a format function in Google spreadsheets. You have to use the TEXT(number, format) function.

I have to admit I always assume it will be format, but Excel uses Text so Google has to use it also.

I use this formula to convert the date time values IFTTT spits out to a useful format:

=VALUE(SUBSTITUTE(A1, " at ", " "))

^{Where A1 is the cell containing the date string}

This gives you a decimal number that you can format as "Date Time".