I need to have my semi-monthly timesheet be able to calculate overtime for people that works 7 days/over 40 hours in more than 5 days. I have the daily overtime over 8 hours, but I can't figure out how to have it calculate for 7 days. Rule is overtime is due if worked more than 40 hours within a week and if worked 7 days in a row. Can anyone follow me, or help me?