Any ideas on how to do the following:

I have a payroll spreadsheet that has columns that show the clock in and clock out time that I formatted the cell to give me miliatary time.  I then have a "sum" column that subtracts one from the other to give me thetotal hours/minutes worked.  I have two of these per date because we work different jobs in one day and I want to create a cell that will take these 2 "summed" columns that have the resulting time worked and add them together and tell me if there is more than 8 hours (for OT sake) and if so, how much more than 8 hours:

Example: summed column A1 says 4:30 and B1 says 5:30

I want the Function column to add A1 and B1 and if it comes out to be more than 8 hours total, I want it to come back with how many hours over 8 it is -- in this case it would be 2 hours more than 8 hours.

Can this be done!



Software/Hardware used:
Excel 2007 and Vista and HP Desktop