To calculate the payment based on the worked hours & rate, we have to multiply each time value by its matching numerical rate.
Let us take an example:
In this example, we will show you how to calculate the number of working hours say 22 hours, & do a simple multiplication with hourly rate to get the payment.
In this tip, Hours x Rate will be multiplied by 24 because Excel treats time formats quite differently than regular numbers.
One day = one whole time unit, therefore one hour = 1/24th of a whole unit, and we must multiply hours by 24 to achieve whole units of time.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
Thank you 🙂
Really helpful, easy to understand and fast. Perfect!!
start: 9.00 am (8 hours) 4.00 pm. after, Starting Hours nomal overtime rate & after 12.00am midnight, after midnight double overtime rate.
whart wre the nomal overtime (time) & double overtime (time) , excel sheet formular?
thanks a lot
Thanks a lot
its work for me and my problem solved
Thank you for the help. This really works.
This is excellent, it works even for minutes and seconds.. Thanks man...