Alright this is exactely what I was looking for! Thanks Peo.

Gabe

"Peo Sjoblom" wrote:

Forget that one, won't work if total is less than a certain number

=--(INT(SUM(A1:A2)/60)&"."&TEXT(MOD(SUM(A1:A2),60),"00"))


--

Regards,

Peo Sjoblom


"Peo Sjoblom" wrote in message
...
As long as you just use minutes like in your example this will work

=--TEXT(TEXT(INT(SUM(A1:A2)/60)&MOD(SUM(A1:A2),60),"00\:00"),"h.m")


--

Regards,

Peo Sjoblom

"Gabe" wrote in message
...
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.