Pau Lo
asked on
integer8 values
I have ran an AD cmdlet report which gives a lot of attributes about users, such as last logon dates. It output the results to a csv file, which i am trying to analyse via excel 2010. From what I have read, the output of what should be dates, is sometimes "Integer8 (64-bit numbers representing dates in UTC)".
e.g.
131054662674668000
130816106481779000
I need a formula to compare these into dates (UK date format; dd/mm/yyyy) I can use and therefore analyse properly, as at present they are pretty useless.
e.g.
131054662674668000
130816106481779000
I need a formula to compare these into dates (UK date format; dd/mm/yyyy) I can use and therefore analyse properly, as at present they are pretty useless.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.