When downloading CSV files that contain time stamps from Inspera Assessment, the data is always recorded in UTC. This article provides a quick and simple way to convert these time stamps to your local time zone using Excel formulas.

Understanding UTC time in CSV exports

Raw data on our servers is stored in UTC, and this data is not automatically converted when the CSV file is downloaded. If you use Excel, you can easily change the time to your current time zone by using a formula that adds or subtracts hours based on the UTC time.

• The formula to add 10 hours looks like this:

  =<cell name>+(10/24)

• The formula to subtract 4 hours looks like this:

  =<cell name>-(4/24)

Import the CSV file to Excel

1. Open a new Excel document and navigate to the Data tab
2. Click From Text
3. Navigate to the CSV file and click Import

Your excel file will look like this:

Add or subtract hours to columns with time stamp

In this example, we're adding 10 hours to lastSaved, and we start with the first cell in the column F2.

1. Create a new column.
2. Add the formula =F2+(10/24) in the first cell in the new column. In the video below, this is G2.
3. Hit enter.

As you can see in the video, this should automatically populate the entire column with the new time value.

Automate by creating a macro

This is possible to automate by recording a macro in Excel. Microsoft has several resources on how to record macros, and to start with you need to add the Developer tab to Excel if it's not already there.

See the following links for more information:

• How to add the Developer tab.
• How to record a macro.