Re: Change base 6 to base 10?

Giganews Newsgroups
Subject: Re: Change base 6 to base 10?
Posted by:  Andre Croteau (miland…@bigpond.net.au)
Date: Tue, 09 May 2006

Hi Brian,

try this:

=(INT(ABS(H2))+((ABS(H2)-INT(ABS(H2)))*10/6))*(H2/ABS(H2))

This will work for both negative and positive.

rgds

André

"Brian Clarke" <Brian.Cla…@REMOVETHISsamuels.co.uk> wrote in message
news:u4Q$el0cGHA.50…@TK2MSFTNGP03.phx.gbl...
>A report I get regularly lists amounts of time in hours and parts of an
> hour. However, the "parts of an hour" are units of 6 minutes, while the
> time
> is listed in "pseudo-decimal" format, like this:
>
> 90 minutes would be        1.3 hours
> 12 minutes would be        0.12 hours
>
> and so on.
>
> I am trying to get the right formula to translate these into decimal
> hours,
> so that
>
> 90 minutes would be    1.5 hours
> 12 minutes would be    0.2 hours
>
> and so on.
>
> The following works for positive numbers, but not negative numbers.
>
> =INT(H2)+((H2-INT(H2))*10/6)
>
> I have tried adapting this formula, but I am getting nowhere. Any
> suggestions would be appreciated.

Replies

None

In response to

Change base 6 to base 10? posted by Brian Clarke on Tue, 9 May 2006