Convert System Log CSV Export Timestamps to a Specific Timezone

This article clarifies how to modify the Zulu Time timestamp (YYYY-MM-DDTHH:MM:ss.sssZ) in a System Log Comma-Separated Values (CSV) export to a different timezone.

• System Log
• CSV Export

Perform the following steps to display System Logs in a preferred timezone:

1. Download the CSV file from the System Logs.

2. Import the file into Microsoft Excel or Google Sheets.

3. Create a new column (for example, timestamp_local) in the file.

4. Use a formula to convert the time to the desired timezone:

   =(DATEVALUE(LEFT(F2,10))+TIMEVALUE(MID(F2,12,12)))+TIME(8,0,0)

NOTE: The following elements in the formula require modification based on the specific requirements:

• • Replace F2 to reflect the actual timestamp column.

  • Replace + to reflect if the offset is positive or negative. For example, GMT+8 uses a plus sign (+), and GMT-8 uses a minus sign (-).

  • Replace 8 with the specific time offset. For example, GMT+8 uses 8, and GMT+11 uses 11.