|I'll figure it out somehow.|
I take it from your question that you are attempting to create some type of
time sheet / schedule program.
I'm not one to re-invent the wheel, so here are some sites with Timesheet/Schedule spreadsheets you can download and review. There are a great many on the web these are just a few.
When you find the one that most fits your needs, if you need help in modifying it come back we'll try to see what we can do.