I need help of the following formula;
Cell L279 is populated by a drop down list.
Cell N279 has the start time
Cell O279 has the finish time
Cell P279 has the break time
Cell U 279 calculates SUM(O279-N279)-P279
I want the cell to also check if L279 is = blank.
How do I nest the formula, taking into consideration the data in L279 is a drop down list of names.