Time recording in excel

i am trying to create a spreadsheet that lists worked hours of a number of men.

The sheet is laid out like this.


Name Time started time finished Actual hours

What i need to do is if a name occurs more than once in column a and his total time is greater or less than eight hours I need to highlight his name. The sheet is a time recording sheet. Any help greatfully recieved. See the attached file if i have done it right

Please read our forum rules and then amend your title accordingly.

That title is no better....