time adding in excell

[Don Scarbrough]

according to the help in Excell-2000 it says to add time
use this formula if the result is to be over 24 hours---
=Sum(cell:cell)*24 the problem is it doesnt work --the
only sum it comes up with is 0:00

 

[Bob Phillips]

Don,

The problem here is that by multiplying the sum by 24, you are changing to
a decimal number of hours, but because you are summing time, the result cell
format defaults to time.

Solution, format the result cell as number, or leave it as time and don't
multiply by 24.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[gaftalik]

Hi ,
Try to format the cells to [h]:mm if that's what you want

Gaftali

 

[Don]

-----Original Message-----
Don,

The problem here is that by multiplying the sum by 24, you are changing to
a decimal number of hours, but because you are summing time, the result cell
format defaults to time.

Solution, format the result cell as number, or leave it as time and don't
multiply by 24.

-- It makes no difference how I format it --it just does not add the cells

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.

 

[Bob Phillips]

Oh, and if using time format it as [hh:mm] as it will probably exceed 24
hours.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Don]

-----Original Message-----
Hi ,
Try to format the cells to [h]:mm if that's what you want

Gaftalik


---
Message posted

.
It still doesn't add the cells together

 

[gaftalik]

Hi,
Lets assume that in A1 you have 12:40 and A2 11:30 .
In A3 Sum(A1:A2) and format A3 [h]:mm which shall result to 24:10

Gaftali