=sumshifts
I have this scheduling template. It was from few years ago and was linked to another budget template. I copied just the scheduling template without the budget. The way it was set up that I can type the hours scheduled in one column like this 8am-5pm for a Monday. It continues to Sunday. The column for total would have this formula =sumshifts(F10:L10). I would get a error message #NAME?.
It worked on the other excel with no problem. It has nothing to do with the budget (budget was calculated on the bottom of the schedule)
How do I get it to work so it can caluclate the total hours scheduled?
Oh, I have excel 2002 if that helps.
Thank you,
Amber
|