Timesheet Formula

Hello,
I am trying to do the following
If an employee works more than 7hrs., any time more than 7 hrs is banked
So i would have another column with the banked time
=if(g10>7,g10-7,0)
if the employee worked less than 7hrs and had some banked hrs, then add the banked hrs to the time to get seven or as close as possible, because maybe there is not enough banked hrs yet to hit 7
any ideas?

What happens if the employeee already has some banked hours?
Your "g10" function will overwrite the previously banked hours.
What should hapopen in that case?

Would be best if you could provide an example of your spreadsheet so we can see how the above relates as an employee accumulates banked hours over days/weeks etc

Hi,

If I'm right, you're trying to work out if the employee has worked more or less than their alloted amount of hours per week.

I've attached a spreadsheet that displays how many hours an employee has worked, and if they've banked some hours, or if they're owing some.

HTH,

SamuelT

Thanks SamuelT,
Here's a zipped copy of the timesheet,
I am having problems with the formula as well
=IF(H7>7,H7-7,"")

Thanks

Thanks works great

Hi, I'm back
On the same sheet
range StartDay is the first day of a month
How can I perform this formula

=(number of workdays for the StartDay month)*7

Thanks Daddylonglegs