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)