ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I calculate total hours by rate of pay? (https://www.excelbanter.com/excel-worksheet-functions/40731-how-do-i-calculate-total-hours-rate-pay.html)

FrankF

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?

Aladin Akyurek



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