I've had issues with this before and was able to get it for comparing times between 9:00 and 10:00 where it was showing 9:00 being greater than 10:00. Now my problem is 90% solved, but I realized my new formula to account for 9 vs 10 is now messing up 1:00 vs 59 seconds. I've attached a workbook to show my exact problem. The formula is pretty long, but hopefully someone can help!
The formula is perfect except for the highlighted yellow row.
Bookmarks