The RETIGO timestamp converter can convert timestamps from a variety of formats to the UTC/ISO 8601 timestamp required by RETIGO. The converted timestamps can be copied and pasted into another application (such as a spreadsheet) to create a valid RETIGO input file. If you do not see a format that matches your data file, please contact the RETIGO development team.

Supported timestamps

• UNIX

  UNIX time is represented by the number of seconds since January 1, 1970, 00:00:00 UTC.

• IGOR

  IGOR time is represented by the number of seconds since January 1, 1904, 00:00:00 UTC.

• Excel serial time

  Microsoft Excel uses a floating point number to represent dates and times. The integer part corresponds to the number of days since a reference day, either January 1, 1900 (Windows) or January 1, 1904 (Mac). The decimal part corresponds to the time of day.

• Matlab

  Matlab time is represented by the number of days since January 0, 0000.

• hh:mm:ss

  This is a generic time representation based upon a 24-hour clock. If you use this format you will be asked to supply the starting date and timezone.

• MM/DD/YYYY-hh:mm:ss

  This is a generic date/time representation based upon a 24-hour clock. If you use this format you will be asked to supply the timezone. Note that the field separator for the date is a forward slash (/), and the date and time are separated by a dash (-).

• YYYY-MM-DD hh:mm:ss TZ

  This is an intenational date/time format that supports international timezone codes. The date, time, and timezone code are separated by a spaces ( ). The timezone code, represented here by "TZ", can be any of the values given in the first column in the table below. The GMT offset and description are provided in the table for reference, but are not included in the timestamp to be converted.