Sum if [Closed]


I am trying to create a formula to calculate my time cards at work

I have afternoon shift, night shift, Saturday, Sunday etc etc.

On a Friday night If my employee works <=5.5 hours then it'll count as afternoon shift. If they work >5.5 I want it to take the excess amount and add it to Saturdays total hours.

Any tips ??

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!