We have a case where our Admins have generated a CSV file with information about user accounts with associated LastLogon date value as a machine numerical value, rather than the human readable date value. A convenient way of expressing that value would be as follows:
1. Create a new column with this formula (tested to work with Excel and Google Spreadsheets):
=IF(G2>0,G2/(8.64*10^11)-109205,"")
2. Format the new column as ‘Date time’ as illustrated below.
Categories: