- One problem, one weekend, eight languages
- How to retrive Outlook default signature
- How to completely uninstall VFP 9.0
- Retrieving VFP runtime DLL name required by EXE or DLL
- Send email via MSN email account
- Send email via Yahoo mail account
- Remove Structural CDX or Memo flag from a table
- Deleting pages from PDF file through Acrobat automation
- GDIPLUS.DLL security updates for VFP 8.0 and VFP 9.0
- Powershell - Benchmark Command
Excel - Convert Unix Time to Excel Time
If you ever find yourself needing to convert from UNIX time in Excel, here's the solution.
Unix time is the number of seconds since January 1, 1970.
Excel doesn't contain built-in functions for working with Unix dates so they must be derived.
Excel allows you to add a number of days to a date by using the "+" operator. Let's make use of that.
First convert the number of seconds to number of days (by dividing by 60*60*24) and then add the result to the date "1/1/1970".
The formula will look like
The quotes around the date are required. If they are not present, Excel will treat 1/1/1970 as an expression.
On Linux (or any other OS that uses coreutils), you can type
to see the current unix time.