yy in excel

Print Thread

Rate Thread

Re: How to convert a MySQL date format to dd/mm/yy in excel 10k #285902 08/05/2005 7:33 AM
Joined: Aug 2000 Posts: 1,609 Las Vegas AKD96 Addict
AKD96 Addict Joined: Aug 2000 Posts: 1,609 Las Vegas	=(A1/86400)+25569 Where A1 contains the epoch time that needs to be translated. Then format those cells (the ones with the formulas) to display as Date and you're good to go.

Sponsored Links

Entire Thread
Subject	Posted By	Posted
How to convert a MySQL date format to dd/mm/yy in excel	Pasqualist	08/03/2005 11:06 PM
Re: How to convert a MySQL date format to dd/mm/yy in excel	AKD96	08/05/2005 2:33 PM
Re: How to convert a MySQL date format to dd/mm/yy in excel	Pasqualist	08/05/2005 3:41 PM
Re: How to convert a MySQL date format to dd/mm/yy in excel	AKD96	08/08/2005 1:14 PM
Re: How to convert a MySQL date format to dd/mm/yy in excel	Pasqualist	08/08/2005 4:05 PM

Hop To

Link Copied to Clipboard

Donate Today!

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.

Recommended Hosts

We have personally worked with and recommend the following Web Hosts:
• Stable Host
• bluehost
• InterServer

Visit us on Facebook

May
S	M	T	W	T	F	S
			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31

Member Spotlight

Gizmo
Portland, OR, USA

Posts: 5,833
Joined: January 2000

Forum Statistics

Forums63

Topics37,573

Posts293,925

Members13,849

Most Online5,166
Sep 15th, 2019

Today's Statistics

Currently Online

Topics Created

Posts Made

Users Online

Birthdays