Tips and Tricks
      Back to home
      1. Rekor Help Center - Knowledge Base & Customer Support
      2. Rekor Scout®
      3. Tips and Tricks

      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)