- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- RE: Change base 6 to base 10?

Subject: | RE: Change base 6 to base 10? |

Posted by: | Stefi |

Date: | Tue, 9 May 2006 |

Do you mean this?

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

Regards,

Stefi

â€žBrian Clarkeâ€ ezt Ãrta:

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

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

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