I am trying to come up with a way to calculate the hours on Excel automatically for my rota. The issue I’m running into is that we do not list “off times” on the schedule, so the shifts are input as “12-cls” or “5-LB”. I am trying to find a […]
Daily Archives: March 10, 2023
11 posts
I have a conditional format in place to highlight text in columns A – I as information is entered in column L. I would like to now delete or change the information in adjacent cells to be blank or 0. For example, when amag is entered in L1, B2 is […]