How do I calculate total hours by rate of pay?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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?
Click to expand...

=TotalHours*24*HourRate
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TIME CALCULATION 5
How do I calculate total pay from [h]:mm times pay rate per hour? 2
currency and time calculation 1
Timecard functions and formulas 1
trouble with calculating wages to hours worked 3
Calculate After hours 3
Timecard question 5
Excel Excel calculate pay based on rate per minute 7

Back
Top