Get Date from Day of Year - 11/18/2003 3:47 AM
I'm attempting to manipulate a flat text file (csv) that stores day/time info in the following format:
YEAR, TIME(24), DAY OF YEAR
eg:
2003, 1500, 310
Which functions would I use to format this into a timestamp:
MM/DD/YYYY HH:MM:SS?
Thank you in advance for any help!
YEAR, TIME(24), DAY OF YEAR
eg:
2003, 1500, 310
Which functions would I use to format this into a timestamp:
MM/DD/YYYY HH:MM:SS?
Thank you in advance for any help!