[robinm]

I have an excelsheet where I have imported tables from stories table. In this table there is a date who looks like this: 1159164181.

Can anyone tell me how i can convert this to a excel date number og date format?

If anyone have a function who allready do this, I'll be very happy.

Best regards
Robin

[Kendle]

Enter =(A1/86400)+25569 into the cell where you want to display the date, where "A1" is the cell containing the timestamp, then format the cell as a date.

You might need to add / subtract a number of seconds for your timezone, as this will give you a GMT date / time.

[robinm]

It works, thanx.

[NanoCaiordo]

Thanks