Adding Time... Varing Values

[santeria]

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

 

[Juan Pablo González]

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

=F13+H13+L13+O13+Q13)

 

[santeria]

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]

Any Suggestions appreciated.


Ta

 

[Yogi Anand]

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]

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]

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....


Adding text time...????

 

[santeria]

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