Posted February 2, 20205 yr It's really disappointing that the time field in log file is not really a time format. Has anyone found a quick method to convert the time field into a real Excel time format?
February 3, 20205 yr 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: =DATEVALUE(RIGHT(D2,LEN(D2)-FIND(" ",D2)))+TIMEVALUE(RIGHT(D2,LEN(D2)-FIND(" ",D2))) 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. Edited February 3, 20205 yr by kclenden
Archived
This topic is now archived and is closed to further replies.