Hi Jake

Presumably those hours are going to have to be counted as part of the next
pay period..
I think the easiest way would be to enter into 2 cells the earliest date you
want to pay and latest date you want to pay.
Then
=SUMPRODUCT((Dates=Earliest)*(Dates<=Latest)*Hour s)
will give the answer.
Substitute the cell ranges for Dates and Hours and the cells where you have
entered Earliest and Latest.
--
Regards
Roger Govier

"Jake F" wrote in message
...
I'm trying to track time spent on a monthly calendar in excel. I need to
create function to total the hours each week and then those are totaled by
month. If the hours are paid on wednesday, is there a way to not
calculate
the hours for monday and tuesday? This is probably more work to setup
than
will save me time, but now that the question is in my head I need to know
if
it's possible.