adding hours and minutes ignoring seconds

[cbm]

I have a column of cells which displays the results of a formula i
hours and minutes (no seconds). For instance A1 shows 3:04 and A2 show
0:18. When I sum these two cells I get 3.23 instead of 3:22. Excel seem
to be counting the seconds too, which results in the additional minut
being added.
How can I make excel add only the hours and minutes without th
seconds?
Thanks - (e-mail address removed)

 

[Ron Rosenfeld]

I have a column of cells which displays the results of a formula in
hours and minutes (no seconds). For instance A1 shows 3:04 and A2 shows
0:18. When I sum these two cells I get 3.23 instead of 3:22. Excel seems
to be counting the seconds too, which results in the additional minute
being added.
How can I make excel add only the hours and minutes without the
seconds?
Thanks - (e-mail address removed)

Perhaps:

=SUMPRODUCT(ROUNDDOWN(rng/TIME(,1,),0)*TIME(,1,))

where rng is the cell reference containing the times you wish to add. Format
the results as [h]:mm


--ron

 

[Haukwa]

cbm,

Try as I might, I could not get the same results as you. My addition
of 3:04 and 0:18 always yielded 3:22. Is there something fishy in the
manner in which your cells are formatted?

 

[cbm]

I have a column of cells which displays the results of a formula in
hours and minutes (no seconds). For instance A1 shows 3:04 and A shows
0:18. When I sum these two cells I get 3.23 instead of 3:22. Exce seems
to be counting the seconds too, which results in the additiona minute
being added.
How can I make excel add only the hours and minutes without the
seconds?
Thanks - (e-mail address removed)

Perhaps:

=SUMPRODUCT(ROUNDDOWN(rng/TIME(,1,),0)*TIME(,1,))

where rng is the cell reference containing the times you wish to add.
Format
the results as [h]:mm


--ron

Thanks Ron, Barry Houdini at mrexcel modified my formula with the roun
function as follows and it works fine. The results are shown in a colum
as h:mm and when I sum the column I get the correct hours and minutes
=IF(F16="SHRUB",ROUND(1.5/(J16*0.75)/3,0),0)/144

 

[cbm]

cbm,

Try as I might, I could not get the same results as you. My addition
of 3:04 and 0:18 always yielded 3:22. Is there something fishy in the
manner in which your cells are formatted?

Thanks for writing - The times shown are the result of a formula an
when I added them I got the incorrect 3:23. Excel kept track of th
seconds even though I had formatted to show only h:mm. Using the roun
function has solved the problem