calculating times
 

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

Hi Keith,

Without being able to see your workbook I'm flying blind here... but you can just use =SUM() to add the cells containing driving time together. Just make sure you custom format it as [HH]:MM . The square brackets will make it add the hours properly rather than loop back round once you get to 24 hrs.

I hope that makes sense and hope it's what you're after.

S.