I need some help with a quick way to convert Julian Date/Time in format ddd.tttttt, to two separate columns. One column should be Calendar Date mm/dd/yyyy and the other time hh:mm:ss. An example:
341.872917 to be converted to 12/06/2009 20:57:00
I'm stumped, any ideas?
I found this on the MS knowledge base:
See the article at http://support.microsoft.com/kb/214099/en-us. The code is approx halfway down the page.
Please Login or Register to view this content.
EDIT: The result given by this formula doesn't match your example answer
Last edited by deadlyduck; 08-12-2009 at 07:58 PM.
Excel 365 user. To unblock a downloaded macro-enabled workbook, go to your "Downloads" folder > right click on the workbook name > click 'Properties' > check the 'Unblock' checkbox. You can now open the workbook.
I've used the above code before but my data has a different format that won't work with it. ie...no year in the data itself
still causing issues...
Assuming your example is correct, ="12/30/08" + A1 and format as you like.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks