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.
|