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.
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

Postby yysniper » Tue Dec 12, 2017 12:06 pm

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

NotNull
Posts: 868
Joined: Wed May 24, 2017 9:22 pm

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

Postby NotNull » Tue Dec 12, 2017 1:20 pm

- 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: 868
Joined: Wed May 24, 2017 9:22 pm

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

Postby NotNull » Tue Dec 12, 2017 2:01 pm

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.
You do not have the required permissions to view the files attached to this post.

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

Postby yysniper » Wed Dec 13, 2017 10:25 am

Thanks NOTNULL
I have found another answer.

Code: Select all

w32tm.exe /ntte the-timestamp

NotNull
Posts: 868
Joined: Wed May 24, 2017 9:22 pm

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

Postby NotNull » Wed Dec 13, 2017 1:55 pm

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


Return to “Support”