This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
This proved very helpful today. Thank you!
I am attempting to do the opposite. My date is in mm-dd-yyyy format, but I need the Excel 5 digit, post 1900 number. IS there a way to convert the date?
RodL--Thank you very much for your solution. After trying it out, I realized your logic was mostly sound but wasn't quite fool-proof since I still got times that were off by 1 sec occasionally. I used your thought process to sketch out a full, fool-proof solution that got me the right answer 100% of the time for the full date & time.
Step 1 - Create the base set of data to work with (all "double" data types):
Step 2 - Resolve the correct date & time parts one at a time using only the base data set (doing this eliminates having to perform the steps in any particular order):
Step 3 - Resolve the date portion of the date & time:
Step 4 - Resolve the full date and time using [DATE_RESOLVED] created in Step 3:
Thank you Jordan!