Formatting Duo Log Reports

If you ever need to export a user's Duo logs in .csv format, it will give you the first column as date & time combined in this format: 

You can use the following formulas to convert this format into two separate cells for date and time (this assumes that the above cell is in A2:

For the date cell, use: =DATE(LEFT(A2,4),RIGHT(LEFT(A2,7),2),RIGHT(LEFT(A2,10),2))

For the time cell, use: =TIME(LEFT(RIGHT(A2,21),2),LEFT(RIGHT(A2,18),2),LEFT(RIGHT(A2,15),2))

Since the times are listed in the UTC time zone, you would need to convert them to the Eastern time zone.

During the summer months, Eastern is UTC-4 (fall/winter, we are UTC-5).  To subtract four hours from the time, add this to the end of the time formula: -(4/24)

e.g. =TIME(LEFT(RIGHT(A2,21),2),LEFT(RIGHT(A2,18),2),LEFT(RIGHT(A2,15),2))-(4/24)