I'm trying something else in the same sheet so maybe you can answer this....
I'm trying to take the values in 2 separate cells which are both a time format "6:30:00 AM" and merge them together using CONCATENATE with a "-" in the middle. Instead of actually displaying 6:30:00 AM - 2:30:00 PM it is giving me a 0.270833333333333-0.604166666666667

Why won't that work?

Again, thanks for all your help! You probably think I'm asking crazy questions, lol.