Is there a way to pick up differences in times between adjacent cells in two columns?
In column F I have start times and a comment, this is usually something like 'Late finish, not legal until 03:45' in the same number cell in column G will be a different time, say '02:30' (Column G only contains times, no comments)
I would like to pick up if there is a difference in the times and highlight the cells in both columns if possible?
The information is F7 to F109 and G7 to G109
Bookmarks