Hi, Is there a way to convert julian dates and times to a standard date using excel I have found a formula that will convert julian dates to a standard date but the data I am giving includes midnight as the time for example for 16/12/2013 00:00:00 I have the code 1387152000 which if I use the standard converter it gives me a date in 2015. Any help would be great.
Edit
This is the current code I have to convert it
=DATE(IF(0+(LEFT(A1,2))<30,2000,1900)+LEFT(A1,2),1,RIGHT(A1,3))
Last edited by Munkle555; 10-22-2015 at 05:16 AM.
Hi please upload an example so I can see what you are talking about?
Thanks
I've found this formula on internet that with your value returns 31/12/2012 but I'm not sure that it's correct:
Regards,
Please Login or Register to view this content.
Antonio
Thank you I cannot seem to find the option to add a attachement though. I have a spreadsheet ready to show you. Thank You Antoka05 sorry going back to my spreadsheet thats the value I get but it should be 16/12/2013
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks