So I'm having a problem trying to make this scheduling sheet..
What I did was row a would be the employee list then b,c,d and so on are mon-sun
Originally in b1 I would put like 9am-5pm and c1 8-4 and so on and in row i I put the total and added a sum function but somehow it wasn't able to calculate.
So then I redid the whole thing this time in row b1 i put 9am and c1 5pm and so on and again I put the total and added the function and it still came out wrong..
If there's anyone here that could help me..there are no words to express my gratitude