Ok so it took a bit and I have this working so that it is giving me the correct outputs.
My question....is there a shorter path to the desired output?
Do I need to convert the time?
Is there a better function I could use for any of the steps?
Any insights would be appreciated.