| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i calculate pay from given hours and pay rates? | Excel Worksheet Functions | |||
| Calculating Overtime from Hours total | Excel Worksheet Functions | |||
| calculate hours just can't figure it out | Excel Worksheet Functions | |||
| calculate difference in time to hours | Excel Worksheet Functions | |||
| Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
Linear Mode
