It's hard to visualize what you mean. Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
I believe that the Excel spreadsheet does not have the capability to achieve what I need. I am trying to set up a "real time" schedule based on the hours in which we work. No weekends, no holidays and only 16 hour days. The formula that you gave me worked but represents that we are working 24 hours a day 7 days a week. Unless I am missing something in the background that could allow what we are looking for.
Exactly what I was trying to avoid. The formula that was inputted was divided by 24 which I think maybe there might be something that we should look at in the background to see if we could adjust to eliminate weekends and holidays and to only have 16 hour days scheduled.