How can i convert the timestamp which in the runhistory file into human-readable time

If you are experiencing problems with "Everything", post here for assistance.
Post Reply
yysniper
Posts: 2
Joined: Tue Dec 12, 2017 11:35 am

How can i convert the timestamp which in the runhistory file into human-readable time

Post by yysniper »

How can i convert the timestamp which in the runhistory file into human-readable time
NotNull
Posts: 5167
Joined: Wed May 24, 2017 9:22 pm

Re: How can i convert the timestamp which in the runhistory file into human-readable time

Post by NotNull »

- Open the CSV in your spreadsheet program

- Assuming the timestamp is in cell C2, enter this formula in cell D2:

Code: Select all

= C2 / ( 8,64 * 100000000000 ) - 109205
- Format cell D2 as Date

See also: viewtopic.php?t=4484
NotNull
Posts: 5167
Joined: Wed May 24, 2017 9:22 pm

Re: How can i convert the timestamp which in the runhistory file into human-readable time

Post by NotNull »

An alternative would be to let Everything itself do the conversion:
(OK, I admit: it's a little bit quick and dirty : -)

- Make a copy of 'Run History.csv' . I called mine TEST.csv
- In Notepad, change the first line of TEST.csv from "Filename,Run Count,Last Run Date" to "Filename,Size,Date Modified" (without the quotes)
- Drag TEST.csv to Everything.exe (or - when in Eveything - open TEST.CSV as a 'File List')
- Enter search query "file:" to get your results (and get rid of the intermediate folders that are in the path to the files/folders in your search history).
The SIze colum actually contains the runcount.
Attachments
2017-12-12 14_58_35-file_ - Everything.png
2017-12-12 14_58_35-file_ - Everything.png (18.65 KiB) Viewed 2436 times
yysniper
Posts: 2
Joined: Tue Dec 12, 2017 11:35 am

Re: How can i convert the timestamp which in the runhistory file into human-readable time

Post by yysniper »

Thanks NOTNULL
I have found another answer.

Code: Select all

w32tm.exe /ntte the-timestamp
NotNull
Posts: 5167
Joined: Wed May 24, 2017 9:22 pm

Re: How can i convert the timestamp which in the runhistory file into human-readable time

Post by NotNull »

Yes, that was also suggested in the link ...
Post Reply