If(Or(InTime="",OutTime=""),"",OutTime-InTime)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary" wrote in message
...
Hi All,

I have a sheet to track the breaks of the team. in the last column i have
total break that is (In time - Out time).

now when a person enters Out time the total beak shows ###### because In
Time is still not there. I tried ISERROR but it didnt work. any ideas?