Use a formula of

=C1-TIME(0,19,0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mailrail" wrote in message
...
I'm attempting to format cells to recognize cells that are greater than
minus
19 minutes (-0:19). So far, it won't work. I've tried using a ' before and
after the time but to no avail. Any suggestions?