Submit a ticket My Tickets
Welcome
Login  Sign up

Spreadsheet Time Format

When exporting plate results from the search page to a spreadsheet (CSV) the output time will be in ISO8601 format.  For example: 2008-09-15T15:53:00+05:00

 

If you wish to convert this to Excel's version, you could try using the following conversion formula:

=DATEVALUE(MID(J2,1,10))+ TIMEVALUE(MID(J2,12,8))-(6/24)

P
Patti is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.