It works! I was scrubbing the data all evening, and I have found nothing wrong at all. I will look a bit more, but this looks right!!

As far as the time zones, I am in central time, as is the time in the data. so thats the reason it needs to add an hour to EST, and drop 1 hour for MST, 2 for PST etc. thanks for your help!!