Convert UNIX time to a regular time

Davers

Well-known Member
Joined
Sep 17, 2002
Messages
1,165
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??? :unsure:

Thanks for the help and have a good day,

Dave
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Davers

Well-known Member
Joined
Sep 17, 2002
Messages
1,165
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...

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

Thanks again and have a good day,

Dave :p
 

Watch MrExcel Video

Forum statistics

Threads
1,122,333
Messages
5,595,560
Members
413,996
Latest member
mabelO

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top