calculating times

[montypython]

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 unformatte
cells so that I can get the total driving time that a particular drive
has done for the month or even for the week.

Thanks and kind regards

Keit

 

[Spencer101]

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 unformatte
cells so that I can get the total driving time that a particular drive
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 yo
can just use =SUM() to add the cells containing driving time together.
Just make sure you custom format it as [HH]:MM . The square bracket
will make it add the hours properly rather than loop back round once yo
get to 24 hrs.

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

S