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.

 Categories: Event Data Loggers, Excel
 Tags: ,
 Bookmark the permalink

 RSS Feed (comments for this post)

 Post a comment

 Trackback URL

Post a Comment

Your email is never published nor shared. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>