I have a huge amount of time entries to compare. Column A would be the Original entry and column B will be either a matching entry or a modified entry which can be greater than or less than the Original entry. I was able to get an answer for the formula where the B entry was greater than the original entry by using "SUM", but cannot figure out how to get an answer where the B entry is less than A.
A B
2:07:39 PM 2:07:39 PM 0:00:00
4:31:24 PM 5:30:00 PM 0:58:36
11:31:16 PM 6:00:00 PM #VALUE!
Bookmarks