Jump to content

Sorting log file using 'DATE/TIME'.


riojp02

Recommended Posts

Posted

When sending the log to Excel, the most recent event is at the end. Ctrl-End will take me there.

 

Unfortunately, you can't sort by date/time. The format of the cell is not able to sort since the 'day' is at the begining.

 

It would be nice if the date/time format would be such that it could be sorted ie: 'yyyy-mm-dd hh:mm:ss'

 

You could then sort in reverse order and immidiately have the most recent event at the top of the spread sheet.

 

You could sort by device and time, to have all the event for one device.

 

Even better, generate the spreadsheet sorted by date/time in reverse order right away. Most recent at the top !

 

Have a very nice week end.

 

Jean-Pierre.

Archived

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

×
×
  • Create New...