Three Level Nested Time Calculation IF Statement

Hello,

While not an Excel guru, I am decent with Excel formulas but am stymied by what I feel is a fairly involved calculation involving dates for timekeeping. I have gotten what I feel is a pretty elaborate IF statement going, but now I need to add a third IF statement and am stuck. What I need is:

If the weekday is Tu/Th, calculate hours against expected 7.75
If the weekday is Mo/We, calculate hours against expected 9
If the weekday is Fr, calculate hours against expected 6.5

I have the following that is working for different hours on Tu/Th and Mo/We/Fr:

A1 is the work date (date format), F1 is the hours worked (General format)
=IF(OR(WEEKDAY("A1")=5,WEEKDAY("A1")=3),(IF(F1-9<-9,,F1-9)),(IF(F1-7.75<-7.75,,F1-7.75)))

I have the following that is working for just Friday:

A1 is the work date (date format), F1 is the hours worked (General format)
=IF(WEEKDAY("A1")=6,(IF(F1-6.5<-6.5,,F1-6.5)))

I am stuck how to nest these separate statements together so I can have the three calculation variations occur. Can someone give me a hand getting this working?

Thanks in advance!

Chris

Hi - thanks for the quick response! I think this is pretty close, but the end result is just the value of F1 as opposed to the calculated over/under that the original IF statements returned. If it makes any difference, the A1 field is a verbose date (i.e., 5/3/2019 8:19:33 AM). The final result of the calculation needs to be the over/under of the expected work hours which is not working in the suggested formula though I really like using the lookup.

This worked perfectly! Thanks a ton for the help!