Originally Posted by

**WendyI**
No. I have that figured out. What i need is the baseline hours for the month. Everyone must work a set number of hours per month. A given day has 7 hours of work time plus an unpaid lunch. That's fine. But we have flex time and people need to know what the base hours for the month are.

So if the regular work month has 31 days, and each work day spans 8 hours, that is equal to 248 hours less one hour of unpaid lunch per day. So I guess really 31 x 7 hours.

I want excel to calculate the hours for each month as I update each year of months. Does that make sense?