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