Actually I need the time to be in a certain integer form so that it can be
multiplied by a set price per minute. Sorry I forgot to clarify that from
the begining. Thanks for the help though.

Gabe

"Alan" wrote:

"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.


Hi Gabe,

I think you are mixing units which is causing the problem.

If you have A1 and A2 as above (I am assuming that the values in each
of those cells is actually 55 rather than '55 mins' which has a value
of 0.03819444...) then you can enter the following formula in A3:

=SUM(A1:A2)/(24*60)

Which evaluates to 0.0763888... which is 1 hour, 50 mins (the standard
unit of time in excel is a day = 24 hours).

To make it display as you set out above, change the number format for
that cell to:

h.mm

I would suggest you don't use that format though. It is ambiguous as
to whether you mean 1 hr, 50 mins or 1.50 hours (which is equal to
1hr, 30 mins).

Personally I would use this format:

hh:mm:ss

The use of a colon is generally accepted to indicate a separation
between hours, mins, and seconds so at least people will know it is a
time value of 1 hr, 50 mins (rather than 1 min, 50 secs).

Obviously you choice though!

HTH,

Alan.

--
The views expressed are my own, and not those of my employer or anyone
else associated with me.

My current valid email address is:



This is valid as is. It is not munged, or altered at all.

It will be valid for AT LEAST one month from the date of this post.

If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address.

The following is a (probably!) totally unique
and meaningless string of characters that you
can use to find posts by me in a search engine:

ewygchvboocno43vb674b6nq46tvb