Re: formating to show quotient and remainder

Giganews Newsgroups
Subject: Re: formating to show quotient and remainder
Posted by:  Peo Sjoblom (terre…@mvp.org)
Date: Wed, 15 Oct 2003

One way with 70 seconds in A1

=A1/24/60/60

format as hh:mm:ss

--

Regards,

Peo Sjoblom

"blm" <anonymo…@discussions.microsoft.com> wrote in message
news:100401c39321$df2e8e80$a30128…@phx.gbl...
> If if am dividing, and want the answer to display as the
> quotient and the remainder (not a fraction or decimal) how
> can I do this without running multiple formulas and
> concatenating them?  For example: I have 70 (seconds) as
> my number.  I want to convert this to minutes to be
> displayed as 1:10 (or 1.10) - I want the integer 1 and the
> remainder of 10 both displayed.  I have managed to do this
> by creating a cell to calculate integer (INT), a cell to
> calculate remainder (MOD) and then another cell to
> concatenate the two previous.  Seems there must be a
> better way!

Replies

None

In response to

formating to show quotient and remainder posted by blm on Wed, 15 Oct 2003