Hi everyone,
I am creating an employee schedule that uses a drop-down list for the manager to select IN and OUT times. The manager would like to use text for certain things like OPEN (9:30 AM) and CLOSE (10:30 / 11:00), and OFF ("blank" or 0:00) and ON CALL ("blank" or 0:00). These times need to be able to be calculated using the following formula:
=IF(D8<C8,D8+1,D8)-C8
where:
- C8 = Start time
- D8 = End time
I have tried to use a very long IF formula to account for this; however, I get an error in the original IF formula at =IF(IF(D8="OPEN";"9:30"~)). This formula is below:
=IF(IF(D8="OPEN";"9:30";IF(D8="CLOSE";"23:00";D8)) < IF(C8="OPEN";"9:30";IF(C8="CLOSE";"23:00";C8)); IF(D8="OPEN";"9:30";IF(D8="CLOSE";"23:00";D8))+"1:00"; IF(D8="OPEN";"9:30";IF(D8="CLOSE";"23:00";D8)))-C8
I have tried to attach the file to the post. I appreciate any help that can be gained.
RokOwen
Bookmarks