Hmm,
Excel allows for a date or time format but not both so if I take the unix value and use that formula get this at date only format

1183780091 7/5/1937

I found a date time format but then get
1183780091 7/5/37 4:08 AM

day/month right but year wrong

Originally Posted by Sirdude
Originally Posted by teamzr1
Sheesh, why cannot they just give a simple formula so I could convert the values on another column in Excel to get the human time/date frown


simple:

assume A1 contains that funky number:

paste '=A1/86400+"1/1/70"' into B1 and format the cell for date/time.. wink

thus: 1183780091 becomes 7/7/07 3:48 AM

*poof* done

JR
Team ZR-1 Corvette Racer's