How do I adjust the time format on a plate export?

You may export plate results to a spreadsheet and then adjust the 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)