Ron,

In the formula you provided, how can I altar it to add a range instead of
only two cells?

Instead of, A1+A2,
Be, the SUM of A1:A20

"Ron Rosenfeld" wrote:

On Mon, 19 Dec 2005 15:06:02 -0800, "Gabe"
wrote:

Hello,

I am trying to add minutes up in Excel, but I can't figure out which formula
to use to display the total correctly? I am trying to add 55 plus 55 as
integers(110), I need the total to be displayed as 1.50 (.50) being the
difference in minutes. Here is a better look.

A1 = 55, A2 = 55, A3 =SUM(A1:A2)/60, A3 displays the value (1.8333).

Is there anyway to display the value as 1.50, instead of (1.8333) and keep
the value an integer? Any help would be greatly appriciated. Thanks.


=INT((A1+A2)/60)+MOD(A1+A2,60)/100

Format the result as number with two decimal places.


--ron