I am working on a form that calculates how many people are scheduled to take phone calls at any given time.
I have a cell with NOW()-INT(NOW()) to give me the current time...
I also have a list in another sheet (secret) with the roster (Name, Line of Business, dates (M,T,W,J,F...), start time...