staffing based off forecasted data,

i have gathered data required to generate my staffing requirements. it is broken down by half hour. my columns days, and my rows are 1/2 hr. increments. in the past they have just guessed what percent should go where, i believe we can create a formula to give me exactly what percentage of my staff should be monday@8, monday@830, monday@9, tuesday@8, tuesday@830 tuesday@9 ect

i am trying to figure out how to create such a formula, or manipulate the data to give me that info.
here is a preview of how the data is gathered. it lines up much better on my sheet, and there is MUCH more data but this is a basic run down.

thanks,

Monday Tuesday Wednesday
Time Fore Req Fore Req Fore Req
8:00 a.m. 0 0 0
8:30 a.m. 0 0 0
9:00 a.m. 75 68 72
9:30 a.m. 88 96 100
10:00 a.m. 103 109 117
10:30 a.m. 116 122 124
11:00 a.m. 103 114 124
11:30 a.m. 127 134 143
12:00 p.m. 128 141 144
12:30 p.m. 124 139 142