Firstly - to avoid confusion - given Paul had outlined an approach for hour.decimal entry I opted to provide an example for hh:mm entry - just in case.

Regards

Quote Originally Posted by darkyam
why would you want it to return $555? 36 minutes = .6 hours, 3.6 * 150 = $540
OP stated

1 to 6 min = .1 (of an Hour)
6 to 12 min = .2
13 to 18 min = .3
19 to 24 min = .4
25 to 30 min = .5
and I assumed the intervals might not be even ie the 1 to 6 and 6 to 12 was unclear given to ceiling of 1 significance the minute break up would be:

1 to 6 = .1
7 to 12 = .2
13 to 18 = .3
19 to 24 = .4
25 to 30 = .5
so perhaps the OP made an error - I wasn't sure... and given OP provided only 5 bands I made up the remainder arbitrarily for sake of demo - to illustrate how a custom minute based calculation could be configured...

If the 1-6/6-12 was an error (ie 1-6,7-12) then yes the bands I provided were inaccurate given they need not be customised but on that basis I also then provided an alternative which used the latter table (which would generate 540 as you mention).

So to surmise, the first example was based upon non-standard minute splits (and people for whatever reason do adopt that approach on occasion), the latter was for standard approach.