difference in 2 times but:-

Assuming that you mean 11 minutes put this formula in Conditional Formatting > New Rule > Use a formula to determine which cells to format:

Please Login or Register  to view this content.

the Applies to would be E4.
Let me know if you have any questions.

really sorry ment 11 hrs only using 1 hr or 1/2 hours

its a time rosta and i am rewriting it but thought there was an 8 minimum but told its an 11 hr minimum so thought id biuld in a check to ensure 11 hr mimimum between shifts

Since it is less than eleven hours and not less than or equal to eleven hours, try this:

Please Login or Register  to view this content.

Let me know if you have any questions.

Russski, you have started several threads with the same question, causing a lot of confusion among people who are trying to help you. I am closing all but one of these threads.

Members should refer to this, the earliest one that has an attachment with a well-formed question.

http://www.excelforum.com/showthread...5256&p=4363372

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.