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

[yysniper]

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

[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]

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.

[yysniper]

Thanks NOTNULL
I have found another answer.

Code: Select all

w32tm.exe /ntte the-timestamp

[NotNull]

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