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.
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):