LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brian Clarke
 
Posts: n/a
Default Change base 6 to base 10?

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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't change x-axis labels getravel Charts and Charting in Excel 2 April 13th 06 03:23 PM
Macro to change Chart Range when inserting a column Mark Charts and Charting in Excel 1 September 13th 05 01:12 PM
change info in other cells when i change a number in a drop list? macbr549 Excel Discussion (Misc queries) 2 September 11th 05 02:07 AM
pivot table with selection values not included in the base data confused Charts and Charting in Excel 0 June 21st 05 02:42 PM
How do I get the font color to change automatically depending on gtcarlsbad Excel Discussion (Misc queries) 2 February 1st 05 02:39 AM


All times are GMT +1. The time now is 05:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"