How do you convert 2016-03-05T08:30:00 to time in google spreadsheet? I would like to convert it to hh:mm:ss. Thanks.
How to convert or parse olson timestamp in google spreadsheet?
google spreadsheets
Short answerAssuming that the value is in A1. Use=TIMEVALUE(Right(A1,8))then apply the desired time format to the cell.ExplanationGoogle Sheets handles date, time and duration data as serial numbers. In several cases, this makes easy to do certain calculations that involves this kind of data. In some circumstances, functions like TIMEVALUE could display a number instead of a time in the desired format but this could be solved by applying the desired format. To apply hh:mm:ss as the number format, click on Formats or the  button o the Google Sheets toolbar, then click on the following path:Number > More formats > More date and time formatsA dialog like the following will be displayed:Click on the drop-down button to select a handler. Then click on the up/down arrows to select the desired format.