Calculating Minutes in Excel
Peo,
This one worked, but now I am trying to add 26.25 plus 3.50, yet I come up
with the answer of 29.75. I need it to read the same way so the value would
be (30.15). Is there a way to modify the current formula so that these values
add in multiples of 60 as well?
A1 = 26.25, A2 = 3.50, A3 = A1+A2,
A3 displays (29.75), can A3 display (30.15) instead?
"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.
|