#### santeria

##### Well-known Member
In some sense this is basic, in some sense not....

I have a Few Columns Where if I add the time Values:

=SUM(F13+H13+L13+O13+Q13)

the Result is sometimes a Time Value.
Equally , it comes up #VALUE, and I have no idea what to look for to correct so that the add up will work.
In theory the sheet ( actually 6 for each Month, covering two months) is giving time in hh:mm:ss , however, this does not seem to be the case.

Is there a formula that will do the above, but take into account slightly variable formatting ( I know, dumb Question) and give a result.
Most result will exceed 100:00:00 in time value.

MMMmmm, what a hair puller.

Ta

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### Juan Pablo González

##### MrExcel MVP
Try removing the SUM(), 'cause anyway, you're not using it at all !

=F13+H13+L13+O13+Q13)

#### santeria

##### Well-known Member
Nope, still fails.

This is soooo aggravating, I know it works in some Part, but then fails in others.

The Alternative is to Concatenate, see the things to be added then..????

#### santeria

##### Well-known Member
Any Suggestions appreciated.

Ta

#### Yogi Anand

##### MrExcel MVP

Hi santeria:

If your entries in cells are in hh:mm:ss, then the result of

=F13+H13+L13+O13+Q13

formated as [hh]:mm:ss should give you the required sum. Perhaps there is a problem with the entries. How about if you post, what is the actual entry in each of the cells ...

F13, H13, L13, O13, and Q13

#### santeria

##### Well-known Member
The formula Works on and off.
I found a manual Work around.

The only thing that seems to be wrong is the formatting.

The Cell Figures are fine. Just that they have different formats, and I can't tell off hand which is which.

If I could change the format for a Whole Row at a Time, without changing the general shape.
I tried getting the Raw data, which would have been easier, but did not work.

I am going to have some coffee now before My hands drop off from typing since 8 am..

#### santeria

##### Well-known Member
If all the Cells to be added are in general format, how do you add them all together?

The basic Formula works on some lines, but not others.

So I took the Cell Values, Brought them Together, and have the Values as separate elements in a cell.

Now, any suggestions on how I can take it from there.

Mmmm, now I just have to find the right report... I wish.. BLECH....

#### santeria

##### Well-known Member
Well, figured out a way around the problem, two ways actually.

Problem was all to do with no zeroes at the start of some numbers.

Not exactly a piece of cake to solve, but do-able

I used some solutions from here too

Ta

Replies
25
Views
911
Replies
2
Views
837
Replies
2
Views
154
Replies
3
Views
282
Replies
3
Views
168

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,152,100
Messages
5,768,095
Members
425,452
Latest member
htay44

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back