Employee Fiscal Year Timesheet

Hi,

I've been trying to work on this problem for hours now and getting nowhere

Please see attached im trying to create a FY13 employee timesheet where it'll calculate total weekly hours, then have a balance at the bottom showing any banked hours +/-. Most employees work 37.5 a week

Is this possible, i'm sure it'll take a pro seconds.

Thanks in advance




Hols & Appointments FY12 ML.xls

It's not fully clear what you need the formula to show. Are you attempting to calculate the hours above/below 37.5? If that's the case, why not a simple formula such as:

Please Login or Register  to view this content.

If it's something more complicated, can you provide some guidance?

Hi,

Thanks for replying

Ignore the formula in cell C9(think i messed up), but i need that to be a weekly total which is simple enough(based on 37.5hrs a week).

But in cell C421 id like there to be a balance of hours they either owe or are owed. so say one day they did an hour less so there weekly total would be 36.5 hours so they owe an 1hr, wondering if its possible to have a running total of hours owed etc in cell C421, or if you have any other suggestions on how to do it, that would be great.

thanks

can anyone assist?