Currently, PADS reports time in seconds-from-midnight format. DMT has developed an Excel Macro that will insert two new columns in a PADS file: the date in YYYY-MM-DD format, and the time in HH:MM:SS format.
Instructions (for Excel 2007):
1.) Open your PADS file in Excel.
2.) Save the document with an .xlsm extension to enable macros. The file name should be kept the same otherwise so that the program can extract the date from the file name.
3.) Click here to download and open the macro.
4.) In the Excel file, click on the “Developer” tab.
5.) Click on “Macros.”
6.) In the box that appears, type “DateTime” for the macro name.
7.) Click on “Create.”
8.) Paste the code in the attached .txt file into the Microsoft Visual Basic editor where the cursor appears.
9.) Back on the spreadsheet, click on “Macros”.
10.) Select “DateTime”.
11.) Click “Run”.
The file should update with the new columns. This may take several minutes.
The macro does not automatically save to a new file. However, the extension is now different (.xlsm instead of the .xlsx file PADS produced), so there is no danger of the original file getting overwritten.
|
