Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,154,809 members, 7,824,371 topics. Date: Saturday, 11 May 2024 at 09:08 AM |
Nairaland Forum / Science/Technology / Programming / How To Convert Excel Time To Normal Time (1314 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)
Artificial Intelligence / Cyber Security Free IT School / .
(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 |