Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hi, I tried to reply to your reply regarding the conversion of seconds to date and time and although I had signed in, I could not get the screen where I could reply to your questions so I found your e-mail address at www.smokeylake.com I am not sure what the number means except that it is supposed to be a date and time that occurred in November, 2005 and the cell contents are under a field called lastlogon. I am trying to convert this to a date and time so that it can be easily determined when a person last logged into his/her account in AD. The file was exported from Active Directory into a CSV file. This number still shows the same in both the text file (in Notepad) and the csv file (in Excel). -- misty1 ------------------------------------------------------------------------ misty1's Profile: http://www.excelforum.com/member.php...o&userid=29112 View this thread: http://www.excelforum.com/showthread...hreadid=488299 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
How to convert DATE and TIME to text | Excel Worksheet Functions | |||
convert interval to various separate date , time, hr, minutes | Excel Worksheet Functions | |||
Convert date to length of time in months from set date | Excel Worksheet Functions | |||
how do I convert a date and time column to a time column | Excel Worksheet Functions |