=(G8<8)*(G80)*ISNUMBER(G8)*(8-G8)
--
John C


"Swtmelly" wrote:

I have a time sheet calculating comp t time used if hours worked (G18) under
8 (based on time in and out)

=IF(G188,0,8-G18)

If the employee doesn't work then I'm also getting answer '8'. How can I
fix the formula so that if there are no times logged in or out I can get the
answer '0.00' or a blank cell?