Create an Excel Macro to Add Seconds to DI-160 Event Data Logger Files

Microsoft Excel automatically assigns a date/time format to files generated by the DI-160 Event, State and Count data logger that does not include seconds (mm/dd/yyyy, hh:mm). As a result, events that occur more often than once a second appear in the data file with the same date/time stamp. While seconds are recorded, they simply aren’t displayed. Rather than reformatting individual data files one step at a time, here’s how to record a macro in Microsoft Excel that will streamline the process.