lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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.
<tbody>
</tbody>
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>
Last edited: