Convert UNIX time to normal

  • Thread starter Thread starter cwalker123
  • Start date Start date
C

cwalker123

Is there a function or calculation that will convert UNIX time to norma
time?
Thanks,
Crai
 
Craig,

=A1/86400+DATE(1970,1,1)

where A1 has the UNIX date/time stamp.

Format for date, time, or date/time.

HTH,
Bernie
MS Excel MVP
 
Back
Top