Posts Tagged ‘Excel’Converting Active Directory Last Logon Time Integer to a Readable Date and TimeSaturday, February 25th, 2012If you have every used CSVDE and exported Active Directory objects, you’ve noticed the integer that represents time. Last logon time is one such value that is represented as this integer. There is a way to convert it to time and date that is human readable. Get the URL from a hyperlink in ExcelSunday, June 14th, 2009Recently I needed to extract a links from a web page; normally I would use some Linux commands ported to windows and get the job done. In the end I needed to format the relative link to a full URL, so I decided to use Excel. However when I imported the web page into excel I found that the URL was embedded in the friendly name of the hyperlink. |
| Copyright - Bohack 2024 © |