The purpose of this workbook is to facilitate calculating local time from the UTC time listed in the LENA .its file.

There are two examples in this workbook:

Option 1. "Update Offset Manually"

• For this option you will export .its files from LENA, add to ADEX, export from ADEX, and add in a formula that will give you the local time.

Option 2.  "Calculate Offset via Formula"

• For this option you will export .its files from LENA, add to ADEX, export from ADEX, and use some lookup formulas to calculate the local time.

The workbook is set up for time zones in the USA. For other time zones, you will need to adjust the DST dates accordingly.