daddylonglegs

This seems to almost work, so I assume I am screwing it up or my description of what I need.
I will try again so please bear with me.

cell A1 = text Month, B1 thru M1 = Jan, Feb, Mar, ect.
cell A2 = text Period Hours, B2 thru M2 = hours in month to date
cell A3 = text In Service Hours, B3 thru M3 = manually entered Service Hours
cell A4 = text Percent Available, Divide Service Hours by Period Hours

All the previous months should have a total of the Period Hours in that month, the current month should only have the current Period Hours and the future months should = 0.

I hope this helps
Thanks for working with me, I will continue to work with your suggestion since it is very close.

Kenny