adding d:h:mm:ss

If they are genuinely formatted time values then you can use just

=A1+B1

or

=SUM(A1,B1)

see attached

what results do you get? How are those values generated - input or formulas?

regards barry
times.xls

barry houdini...attached is my sheet ...
Need to add   B AND C and give me the correct value in  D..

Usage-Report.xls

Your data is text formatted so If the values never have days then you can use simply

=RIGHT(B2,8)+RIGHT(C2,8)

....but if days might be included (or the total might take it over 1 day) then you need a version of the formula I posted above, i.e.

=INT(RIGHT(B2,8)+RIGHT(C2,8)+LEFT(B2,FIND(":",B2)-1)+LEFT(C2,FIND(":",C2)-1))&TEXT(RIGHT(B2,8)+RIGHT(C2,8),":hh:mm:ss")

see attached where I put the first formula in E2 and the second in F2, both copied down - note they give the same results for your data because the day totals are all zero - I added a row (row 7) with days included. In which case only the longer formula gives the correct result

regards, barry
Usage-Report-barry.xls

OK, sorry, I was only looking at data in 2011....didn't see 2010!

You need the longer formula to work consistently for all the data, i.e. this version in 2010 sheet J2 copied down

=INT(RIGHT(H2,8)+RIGHT(I2,8)+LEFT(H2,FIND(":",H2)-1)+LEFT(I2,FIND(":",I2)-1))&TEXT(RIGHT(H2,8)+RIGHT(I2,8),":hh:mm:ss")

and similar for 2011 sheet as suggested above

Formula returns a text value (your existing data is also text). It isn't possible to be anything other than text if you need to show totals of 31 days + in that format.

see revised attachment

regards, barry
Usage-Report-barry-v2.xls

Perfect Thanks !