rota

Not that you need to know but let's start over as my post didn't save when I clicked back from the preview :cry: So.... I have a staff rota that tracks the number of days someone has worked and on another sheet based on the number of days worked the number of total hours worked. The query is...

Hey all, I'm trying to work formula to see if a staff was in, it will show their shift hours if its Mon-Thu or Fri. I've listed the shift times in 2 columns. I'm using as an example, =TEXT(F5,"ddd") to display the weekday. So the following formula works where it checks conditional formatting on...