To catch up on the thread that was first posted and thought SOLVED use link below
http://www.excelforum.com/excel-form...d-formula.html
Well it turns out the formulas given only partially work as can be seen in the attached sample.
The load time in column B i believe is what governs the reply in column V, depending on data put in columns L - O.
The answers of Y or N work only for column O but need it also to work if only 2 times are entered and therefore column M comes into play.
In rows 15 onwards I have highlighted some of the wrong ones. As you can see in example at row 15, 13:00 load complete @08:22 and yet column V marks as N, making it a late when it wasnt.
Is there an addition to the formulas in column V which would sort this issue out?
Bookmarks