Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,194,827 members, 7,956,129 topics. Date: Monday, 23 September 2024 at 04:03 AM |
Nairaland Forum / Science/Technology / Programming / How To Convert Excel Time To Normal Time (1330 Views)
How To Convert Numbers To Words In Excel / How To Convert Folder/file To Jpeg Format / How To Convert A 20-digit Numeric Value From Base10 To Base36 In C# (2) (3) (4)
(1) (Reply)
How To Convert Excel Time To Normal Time by luckyCO(m): 1:55pm On Aug 12, 2011 |
Helo I extracted a list of data containing time and I discovered that the system concerts time column to numbers like 40605.5830787037 I have tried all what I can to revert but stil didnot work. Any help in the floor |
Re: How To Convert Excel Time To Normal Time by dellnet: 2:01pm On Aug 12, 2011 |
change the column type to date/time |
Re: How To Convert Excel Time To Normal Time by luckyCO(m): 2:27pm On Aug 12, 2011 |
Thanks,it worked like fire. God bless you |
(1) (Reply)
How Can I Build A School Forum? Pls I Need Help (assignment) / Get Top 10 Facebook Tips / Do We Really Have Wizard Female Programmers In Nigeria?
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 5 |