How do I calculate total hours by rate of pay?

F

FrankF

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?
 
A

Aladin Akyurek

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

Calculate Total Hours when Overlapping Occurs 0
How do I calculate total pay from [h]:mm times pay rate per hour? 2
calculate total hours based on dates 5
Calc staff vacation time based on more than 1 criteria 0
trouble with calculating wages to hours worked 3
Variable Pay-rate after 5pm 1
Timecard functions and formulas 1
Timecard question 5

Top