multiple total time by number

[lezawang]

Hi I want to add time then multiple the result by rate which is 10.
So I have my time formatted as hh:mm
then I used =Sum(B1:B4) to find the total which is 21:00
Now I want to multiple 21:00 by 10 to find how much to pay
I got 18:00, clearly that is wrong. So I convert the total pay cell to general and I got 8.75
then I multiple that number by 24 to get 210 which is the right number.

How you would do that? Is there better way? I understand why I need to multiple by 24 but can I avoid this step by changing format of the total hours and then multiple them by rate? Thank you so much.

	1:00
	10:00
	2:00
	8:00
total hrs	21:00
rate	10
total pay	18:00

<tbody>
</tbody>

 

[James006]

Hello,

Have you tried to format your Total Hours with [hh]:mm format ?