Hello everyone,

I was hoping someone would have some insight into my problem. I have created a sheet that determines at what percentage and how to treat an employee who is returning from a seasonal layoff. In this case a daycare worker is returning. For these employees if the gap between one of their daily blocks is greater than 1.5 hrs they receive a split shift premium. There is the main schedule entries and a hidden table that calculates these time gaps. Then an IF forumla with a nested OR formula determines if the split shift premium is allowed.

The problem: If there is a blank entry in one of the fields from the drop down list (say they only work in the afternoon) it treats this unselected field as 12:00am and gives an innacurate calculation. Is there a way to have an unselected field in a drop down list default at 0?

Thank you very much, always appreciated,

-Dawson

Excel HELP.jpg