|
Converting Unix date to mmddyyyy:hr:min:sec format within Excel
I need to convert a column full of numbers representing date in Unix format
to the Windows date mmddyyyy:hh:mm:ss format. Can anyone provide me a macro which can do this for a column full of data? A sample of the data (in Unix Date format) is listed below: 1181846741 1181930850 1182017262 1182096202 1182182688 1182269074 1182355470 1182441813 1182528209 1182614575 1182731309 1182787489 1182873806 1182960243 1183046665 1183133077 1183219376 1183305815 1183392260 1183478655 1183565047 1183651427 1183737883 1183824182 1183910610 1183997155 1184083549 1184169943 1181846625 1181846741 Thanks in advance for your help regards PiyushAg |
Converting Unix date to mmddyyyy:hr:min:sec format within Excel
Assuming your unix times are in a1 down put this in B1 and drag down
=A1 / 86400 + 25569 Format as date Mike "PiyushAg" wrote: I need to convert a column full of numbers representing date in Unix format to the Windows date mmddyyyy:hh:mm:ss format. Can anyone provide me a macro which can do this for a column full of data? A sample of the data (in Unix Date format) is listed below: 1181846741 1181930850 1182017262 1182096202 1182182688 1182269074 1182355470 1182441813 1182528209 1182614575 1182731309 1182787489 1182873806 1182960243 1183046665 1183133077 1183219376 1183305815 1183392260 1183478655 1183565047 1183651427 1183737883 1183824182 1183910610 1183997155 1184083549 1184169943 1181846625 1181846741 Thanks in advance for your help regards PiyushAg |
Converting Unix date to mmddyyyy:hr:min:sec format within Excel
See
http://www.mcgimpsey.com/excel/udfs/unixtoxltime.html -- Kind regards, Niek Otten Microsoft MVP - Excel "PiyushAg" wrote in message ... |I need to convert a column full of numbers representing date in Unix format | to the Windows date mmddyyyy:hh:mm:ss format. | Can anyone provide me a macro which can do this for a column full of data? | A sample of the data (in Unix Date format) is listed below: | 1181846741 | 1181930850 | 1182017262 | 1182096202 | 1182182688 | 1182269074 | 1182355470 | 1182441813 | 1182528209 | 1182614575 | 1182731309 | 1182787489 | 1182873806 | 1182960243 | 1183046665 | 1183133077 | 1183219376 | 1183305815 | 1183392260 | 1183478655 | 1183565047 | 1183651427 | 1183737883 | 1183824182 | 1183910610 | 1183997155 | 1184083549 | 1184169943 | 1181846625 | 1181846741 | | Thanks in advance for your help | regards | PiyushAg |
Converting Unix date to mmddyyyy:hr:min:sec format within Excel
Not a macro, but
http://exceltips.vitalnews.com/Pages...me_Stamps.html -- David Biddulph "PiyushAg" wrote in message ... I need to convert a column full of numbers representing date in Unix format to the Windows date mmddyyyy:hh:mm:ss format. Can anyone provide me a macro which can do this for a column full of data? A sample of the data (in Unix Date format) is listed below: 1181846741 1181930850 1182017262 1182096202 1182182688 1182269074 1182355470 1182441813 1182528209 1182614575 1182731309 1182787489 1182873806 1182960243 1183046665 1183133077 1183219376 1183305815 1183392260 1183478655 1183565047 1183651427 1183737883 1183824182 1183910610 1183997155 1184083549 1184169943 1181846625 1181846741 Thanks in advance for your help regards PiyushAg |
Converting Unix date to mmddyyyy:hr:min:sec format within Exce
Sorry I should have added youcan format up to this level of precision:-
dd/mm/yyyy hh:mm:ss Mike "Mike H" wrote: Assuming your unix times are in a1 down put this in B1 and drag down =A1 / 86400 + 25569 Format as date Mike "PiyushAg" wrote: I need to convert a column full of numbers representing date in Unix format to the Windows date mmddyyyy:hh:mm:ss format. Can anyone provide me a macro which can do this for a column full of data? A sample of the data (in Unix Date format) is listed below: 1181846741 1181930850 1182017262 1182096202 1182182688 1182269074 1182355470 1182441813 1182528209 1182614575 1182731309 1182787489 1182873806 1182960243 1183046665 1183133077 1183219376 1183305815 1183392260 1183478655 1183565047 1183651427 1183737883 1183824182 1183910610 1183997155 1184083549 1184169943 1181846625 1181846741 Thanks in advance for your help regards PiyushAg |
Converting Unix date to mmddyyyy:hr:min:sec format within Exce
Worked like a charm - a 10
Thanks Mike Regards PiyushAg "Mike H" wrote: Assuming your unix times are in a1 down put this in B1 and drag down =A1 / 86400 + 25569 Format as date Mike "PiyushAg" wrote: I need to convert a column full of numbers representing date in Unix format to the Windows date mmddyyyy:hh:mm:ss format. Can anyone provide me a macro which can do this for a column full of data? A sample of the data (in Unix Date format) is listed below: 1181846741 1181930850 1182017262 1182096202 1182182688 1182269074 1182355470 1182441813 1182528209 1182614575 1182731309 1182787489 1182873806 1182960243 1183046665 1183133077 1183219376 1183305815 1183392260 1183478655 1183565047 1183651427 1183737883 1183824182 1183910610 1183997155 1184083549 1184169943 1181846625 1181846741 Thanks in advance for your help regards PiyushAg |
| All times are GMT +1. The time now is 11:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com