Tanya Berfield wrote:
I thought that did it but not quite. In P i have total hours worked, if AO
shows T (true) and P is more than 5 i need to deduct .5 - am i missing any
info?



A complete cell reference has a column letter and a row number (A1 through
IV65536 until the most recent version). So, in exactly what cells are each of
these pieces of information?