Yes that is sort of what I want but what I am looking for is a formula that is sort of like a if then statement or calculation that says

if it is after todays date then put however many hours is left between now until sept. 20th 2013 otherwise sum the total hours in column C:C that has the name "Jack" in column B:B that has the pay type "REG" in column D that falls under the dates 8/1/2013 in column A:A and Date 8/2/2013 in column A:A. So on and so forth for each column in my spreadsheet.

Right now I have my spreadsheet to where I manually have to go in there and and add 40 hours or however many hours are in each date range remaining and then as each date range passes I remove that amount of hours I would like to not have to do this because it leaves room for errors and leaves room for me to forget to go in and manually do something and then my $$ money numbers will be off and that is never good.

I hope that better explains what I am looking for