I am attempting to create a timesheet where hours worked are entered as
"start time", "finish time" and "break length", therefore 1st cell may be
05:30, 2nd cell 17:00, 3rd cell 00:30 and 4th cell is total time worked ( 11
hours).
I also have a column that states the type of day worked eg. "Standard",
"Saturday", "Sunday", Public Holiday" etc. The day worked determines the
breakup of hours betwen different pay rates. I would like to create a formula
for the following criteria:
(A1) is "Day Type" (A5) is "total Hours Worked" (A6) is "normal
hours" (A7) is "overtime hours", therefore IF
- (A1) is "Saturday" and (A5) is equal to or greater than 2 then 2
- (A1) is "Saturday" and (A5) is less than 2 then (A5)
- (A1) is "Standard" and (A5) is greater than 9.6 then 2
- (A1) is "Standard" and (A5) is between 7.7 and 9.5 then (A5) minus (A6)
- (A1) is "Standard" and (A5) is equal to or less thans 7.6 then (A5)
- (A1) does not equal "Saturday" or "Standard" then 0.

I have tried a combination of IF(AND) and have been unsucessful, any help
would be much appreciated.

I am running Excel 2003.