first sheet ;
A1 is the earliest time an employee can start
B1 is the latest an employee can stay
A1 is the time an employee is schedule to start work
B1 is the time an employee is schedule to end work
this is where i need help.
A1 and B1 are to be filled with formulas that reflect the remaining availability an employee has after being scheduled on "sheet 2".
i hope this is clear. the file i have is quite massive and contains sensitive information so i don't want to post is here.
i appreciate your help!!