delboy1616
New Member
I would like to change the start time for a "Tuesday which is held within a formula. I am not sure how to do this. I have created this formula but the first "if" doesn't seem to work. it steps through to the second "if" statement. I would appreciated some advice please.
Here is the formula IF(F5="Tue","10:00",IF(F5>F4,"9:00",IF(B4="","",IF(F4="","",B4)))) I have a sample xls attached
Thanks
Here is the formula IF(F5="Tue","10:00",IF(F5>F4,"9:00",IF(B4="","",IF(F4="","",B4)))) I have a sample xls attached
Thanks
Attachments
Last edited: