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.

[TABLE="class: grid, width: 128"]
<tbody>[TR]
[TD][/TD]
[TD="align: right"]1:00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]10:00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2:00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]8:00[/TD]
[/TR]
[TR]
[TD]total hrs[/TD]
[TD="align: right"]21:00[/TD]
[/TR]
[TR]
[TD]rate[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]total pay[/TD]
[TD="align: right"]18:00[/TD]
[/TR]
</tbody>[/TABLE]

 

[James006]

Hello,

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