Hi there

I need some input and hope somebody can help me

I have a spreadsheet with 5 or 6 different workers, and driving times, if they drive more than 10 hours, I have formatted the cell to turn red, what I need to do is add up both the formatted cell and the unformatted cells so that I can get the total driving time that a particular driver has done for the month or even for the week.

Thanks and kind regards

Keith