Conditinal Formatting Hours of Service

EmjBCPWT 

You'd help others help you if you could be a bit more explicit or descriptive here. What you have is a relatively complex spreadsheet (it may not appear so to you because you created it and therefore KNOW personally all the relationships between tabs and tables and cells).

So if you could point to the cell(s) in question rather than just assuming it's obvious, it would save a lot of time.

That said, I am noticing that although the "Run Times" table has times noted, with I think only two exceptions, there are no dates associated with those times. I do believe the calculation for the "less than 8 hours" condition would be a lot more reliable if the cells in question contained both date and time, even if only the time were to be displayed. And that might well solve your problem.
"