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

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

robinm Offline Joined: Jun 15, 2010 Posts: 2 0 👍 / 0 👎	Tue Jun 15, 2010 7:43 am 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 Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS): linux/8
Kendle Offline Joined: Dec 16, 2004 Posts: 569 0 👍 / 0 👎	Tue Jun 15, 2010 11:41 am 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):
robinm Offline Joined: Jun 15, 2010 Posts: 2 0 👍 / 0 👎	Tue Jun 15, 2010 11:48 am It works, thanx. Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS): linux/8
NanoCaiordo Offline Joined: Jun 29, 2004 Posts: 4297 Location: Italy 0 👍 / 0 👎	Wed Jun 16, 2010 8:29 am 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 Post new topic Reply to topic Forum Index ⇒ Explain Please Page 1 of 1