Please help w/formula
=IF(A3<A2,A3+1-A2,A3-A2)*24*B2
Where A2 is start, A3 is finished, B2 is rate of pay
Format cell to currency or accounting.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Dave" wrote:
I want to create a formula for an employee schedule to compute the totals hrs
scheduled, multiply total hrs scheduled by rate of pay to get a gross rate of
pay. I can only get it to add up to 24 hrs then it starts over at 1.
Example I am using:
Start:17:00
End: 19:00
Total: =(end-start)
|