Time range formula

If you're already entering the number .8 into a cell, to get the correct value just use

=150*B1

Where B1 contains .8

Or are you trying to calculate the .8 based on the number of minutes you input?

Yes I am trying to calculate the number basedon the numbers of minutes I input and the amount

If you gave some examples of your "entries" that would help as I think that's what's preventing you from getting a quick resolution.

If you're saying you work 3 hours and 36 minutes and you enter that into say A1 as

3:36

then to get your total you could use something like

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

would generate 555

change the values in in the line array to match your requirements - you must leave the 0 though... in the above 1-5 would generate 0.1, 6-12 -> 0.2 etc...

It's a shame you need to specify like the above as obviously

=150*(CEILING(A1*24,0.1))

is a lot simpler but in this case would generate 540

I am attaching an example of the entries that I am doing. I am not entering any formulas yet.

I hope it helps