excel formula to convert server time in seconds

F

frogman1001

I extracted data from my server. It keeps a log of time like this
1069255091 (this morning)

I converted the data into excel but now I need this cell value to b
the actual date and time.

Any one have the easy answer
 
P

Peo Sjoblom

One way

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

format result as

mm/dd/yy hh:mm:ss

or whatever your date format is, since I got 11/19/03 15:18:11

you might be in UK and change the date format accordingly
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date diffrence in days, weeks and months. 1
Autonumber field in Excel that behaves the same as Access 0
I am looking for a formula which extracts a list from data in sheet1to sheet2 filtered by a starting 1
Converting SQL server time to date and time 1
HELP: Adding data from Cells B1, B2, B3 etc. into COL F every other12 rows. 16
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Formula within Pivot Table Calculated Field - Days in time period 0
Excel suddenly crippled by Just-In-Time Debugging 2

Top