Adding Time... Varing Values

santeria

Well-known Member
Joined
Oct 7, 2003
Messages
1,844
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

(y)
 

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.

santeria

Well-known Member
Joined
Oct 7, 2003
Messages
1,844
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..????

:unsure:
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454

ADVERTISEMENT

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
Joined
Oct 7, 2003
Messages
1,844
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..


:eek:
 

santeria

Well-known Member
Joined
Oct 7, 2003
Messages
1,844
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...????


:unsure: :unsure: :unsure:
 

santeria

Well-known Member
Joined
Oct 7, 2003
Messages
1,844
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 :p

Ta

(y)
 
Master Excel Bundle

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.

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top