I have a good schedule but I need to add words such as Off, Request Off, Vacation and etc. When I do this, it messes up my formula because it only recognizes time. It adds that time for me to show the employees hours. I need each of these words to represent a 00:00 time so it will not mess with my formula. I want it to show the word in the place of the 00:00 time though! My times are chosen as start and end times form a drop down box I created. Schedule works great. Just need words also
Bookmarks