Please help w/formula
 

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)

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)

Please help w/formula
 

On Dec 18, 12:49*pm, 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)

Dave,
I think you need to enter the hours as hr:min:sec format so 5pm is
17:00:00.

Please help w/formula
 

Try these:

=MOD(end-start,1)

To get the total hours:

=SUM(range)

Format as [h]:mm

The brackets [ ] keep the hours from rolling over and restarting after 24

To calculate gross pay:

=Total_Hours*24*Pay_Rate

--
Biff
Microsoft Excel MVP


"Dave" wrote in message
...
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)