Nested IF Statement-complex

[Kheldar]

Hey all, hoping somebody can help me formulate a complex nested IF statement.

I've got 8 conditions I need a cell to be checked for, they are as followsS=Start Time formatted as 1/1/11 17:35, F=Finish Time formatted the same)

1. S>6:00, F>14:00=14:00-S
2. S<6:00, F<14:00=14:00-F
3. S>6:00, F<14:00=F-S
4. S<6:00, F>14:00=Rate x 420
5. S>14:00, F>6:00=F-6:00
6. S<14:00, F<6:00=14:00-6:00
7. S>14:00, F<6:00=0
8. S<14:00, F>6:00=14:00-6:00, F-6:00

I've tried every way of formulating that I know of, to know avail. Hoping one of you Excel geniuses can help me out.

Thanks very, very much!


-Nick