Excel: Convert base10 to base6 2

[krets]

How would I convert a base10 number to a base6 number?

For instance:

I would like 10.5 minutes to display as 10:30.

Thanks.

 

[xlhelp]

Divide the minutes by 1440 and custom format to mm:ss

Member- AAAA Association Against Acronym Abusers

 

[AnotherHiggins]

To convert 10.5 to 10 and 1/2 hours, divide by 24.

To convert hours to minutes, divide by 60.

So =A1/24/60
or [COLOR=blue white]=a1/1440[/color

Format the result as Custom > mm:ss or [m]:ss

For further explanation, see faq68-5827.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[xlhelp]

I tend to give short answers. So here is an explanation.

1 day has 1440 minutes. Time in Excel is measured in terms of days or a fraction of a day. So, converting the minutes to fraction of a day and then custom formatting the cells to mm:ss will give you the result you desire.

Member- AAAA Association Against Acronym Abusers

 

[xlhelp]

Krets,

Mr Higgins types faster than me and puts some forethought into it. Hope you got your answer.

Member- AAAA Association Against Acronym Abusers

 

[AnotherHiggins]

I goofed my TGML code. My second formula should have read
[COLOR=blue white]=a1/1440[/color]

[aside]
You are too kind, xlhelp

[/aside]


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[krets]

Perfect. Thanks to both of you.