Time range formula

First off... I know you know this but I am just posting to try and account for any and all confusion caused by my prior post(s) ...

Originally Posted by d

I was just curious how :36 came out to .7

Via the MATCH.

(MATCH(MINUTE(A1),{0,1,6,13,19,25,31,36,41,47,53})-1)/10)

The MATCH for minute 36 would return 8 from which we must subtract 1 (to account for min 0).
We then divide the adjusted output by 10 to get the decimal.
The decimal is then added to the hour to give us our value against which we multiply the hourly rate.

And to reiterate the above is only a worthwhile approach if you wish to "customise" (from the norm) the minutes apportioned to each 10% of the "hour" - if not then there's zero need for it.