Time Values Appear Truncated When Viewed in Microsoft Excel.

October 18, 2004 | KB: 1000755
Audit Trail 7

Summary

Audit Trail allows you to export a report as a text file. When you view the exported report in Microsoft Excel, the time value in the Event Time column is shown in 24-hour format without the seconds value.

Resolution

The seconds value is not lost. This is a formatting issue within Microsoft Excel. Double-click an entry to display the full time value.