this seems to work. I am just wondering if the date will stay the same when i open the file on another day.

thanks

Also any advice on this problem???

I would like to count only when "yes" is entered into a cell and to do so on a 24 hour time table with the totals resetting to "0" when a new day starts.
Also would like to do the same in another total it for the month based on a date format of 11/15/13 from another cell.

1st: Hour formula:

B24 = formula
C29 = where "yes" or 'No" will be entered

count on a 24hour time table only when "yes" is entered.

2nd: Monthly Formula:

Q4 = Formula
B29 = Date (format is 11/15/13) however if that needs to change let me know.
C29 = where "yes" or 'No" will be entered

count when "yes" is entered for that particular month