Jump to content

Any quick method to make the "time" field of log file in Excel format "date & time" format?

Recommended Posts

3 hours ago, ISY Newbie said:

Has anyone found a quick method to convert the time field into a real Excel time format?

I just convert the value in Excel by adding another column with the following formula:


This assumes that your log looks like mine and the ISY "Time" appears in column D.  It converts the text in column D into a DateTime serial number in Excel.  You can then choose to display it using any date format you want, as well as perform subtraction and addition to determine the time elapsed between dates.

Link to comment


This topic is now archived and is closed to further replies.

  • Create New...