Adding hours, minutes and seconds

[Audiojoe]

I've got a column that looks like this:

12:10:10
15:32:01
14:49:20 etc...

What I need to do is add a few of them together, but the total keeps coming out as the time, when I just want it to show as the total amount. E.G: If I add 12:10:10 and 15:32:01 together, I want it to say 27:42:11 because that's the total

It's probably really easy, but I can't seem to get going today

Help an old soldier

 

[Dave Hawley]

Hi Audiojoe

Custom Format your result cell as [h]:mm:ss

 

[Derek]

Hi Audiojoe

Try custom formatting the cells that hold your total as [hh]:mm:ss

good luck
Derek

 

[Derek]

Hi Audiojoe

Try custom formatting the cells that hold your total as [hh]:mm:ss

good luck
Derek

 

[Aladin Akyurek]

On 2002-04-10 05:59, Audiojoe wrote:

I've got a column that looks like this:

12:10:10
15:32:01
14:49:20 etc...

What I need to do is add a few of them together, but the total keeps coming out as the time, when I just want it to show as the total amount. E.G: If I add 12:10:10 and 15:32:01 together, I want it to say 27:42:11 because that's the total

It's probably really easy, but I can't seem to get going today

Help an old soldier

Custom format the cell of the formula that does the summing as:

[h]:mm.ss

Aladin

 

[Audiojoe]

My boys, my boys

You've made your old dad very happy


Thank You
Audiojoe
Now get to bed