Support ⇒ Explain Please ⇒ [how to] Convert GMT timestamp into excel date ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum IndexExplain Please

[how to] Convert GMT timestamp into excel date Reply to topic


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. Very Happy

Best regards
Robin

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
linux/8


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.

Gaming League / Cup - www.leaguecms.co.uk :: Other DragonFly modules - www.cmsdreams.co.uk

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


It works, thanx.

Big grin

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
linux/8


Thanks

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS

All times are UTC


Jump to: