# Making A Roster

Mar 30, 2007I have been asked to make a formula that sums up the hours in a week and then tells me whether I am below or over the budgeted hours for that week!

I cant get it to work since I cant figure out how to have the same formula in all the cell that sums up early, mid and late shifts, ie 06-14, 14-22, 22-06.

The graveyard shift is a problem there since I get negative hours.

Further more, I need to have the formula ignore cells to be added up if it has letters in it, we write an R for Rostered day off.