![]() |
How do I calculate total hours by rate of pay?
I am using a "start" time and "End" time field then calculating total hours
by using the following formula =C2-B2+(C2<B2) which brings me the result for total hours spent on any given project. How can I apply these result to a rate of pay per hour to receive a total amount due for my projects? |
FrankF wrote: I am using a "start" time and "End" time field then calculating total hours by using the following formula =C2-B2+(C2<B2) which brings me the result for total hours spent on any given project. How can I apply these result to a rate of pay per hour to receive a total amount due for my projects? =TotalHours*24*HourRate |
All times are GMT +1. The time now is 06:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com