If the time in one column is over 07.30 (7 hours and 30 mins) then I want it to do another calculation. Leaving the remaining minutes over 7hrs 30 mins
Am I on the right track with something like this
Please note D6 would be time out and C6 time in
=if(E6<=TIME(7,5,0)," ","SUM(D6=C6)
Bookmarks