time adding in excell

D

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
 
B

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)
 
D

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)




.
Click to expand...
 
B

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)
 
G

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
 
Top