multiple total time by number

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,543
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 hrs21:00
rate10
total pay18:00

<tbody>
</tbody>
 
Last edited:

Forum statistics

Threads
1,085,175
Messages
5,382,142
Members
401,775
Latest member
BredAnderson

Some videos you may like

This Week's Hot Topics

Top