Convert UNIX time to a regular time

[Davers]

Hi everyone. Get this, I have a database that is housing a persons log in time and log out time for the day in UNIX time. Which is the number of seconds since January 1st 1970...Does anyone know how I can convert that number into a normal time? For instance, I logged in at 6:16 am this morning. It shows up as this number: 1107929811

Does anyone know how to convert that into a time???

Thanks for the help and have a good day,

Dave

 

[JWARD]

if unix time in a1
in b1 =A1/86400+"1/1/70"
and format cell as time
or date for date
should do it

online conversion at http://www.onlineconversion.com/unix_time.htm

 

[Davers]

Thanks very much!!!! I really appreciate it!!! And just in case anyone is interested...my boss created this little function to convert Unix time to a readable time...

Public Function SillyUnix(LucentTime As Double) As Date
    SillyUnix = 25569 + (LucentTime / 60 / 60 / 24)
End Function

Thanks again and have a good day,

Dave