Hello,
If I open Search History.csv using Excel, the Last Search Date is a large number, such as '133009848156294000.00'. Is there an Excel Date/Time format that will display dates such as '06/30/2022 01:44 PM'. I have tried many Custom, Date and Time formats, but none will display a readable date. What does this large number represent?
Last Search Date format in Search History.csv
Re: Last Search Date format in Search History.csv
Everything stores dates as FILETIMEs.
To convert a FILETIME to a date in excel, use the following formula:
=((C2-116444736000000000)/864000000000)+DATE(1970,1,1)
where C2 is the cell to convert from a FILETIME to date.
https://stackoverflow.com/questions/42135186/how-to-convert-a-filetime-to-an-excel-date
To convert a FILETIME to a date in excel, use the following formula:
=((C2-116444736000000000)/864000000000)+DATE(1970,1,1)
where C2 is the cell to convert from a FILETIME to date.
https://stackoverflow.com/questions/42135186/how-to-convert-a-filetime-to-an-excel-date