EXCEL -FORMULA

Hi Tracey

Sorry about that - you can send an email through to amanda@stl-training.co.uk

thanks
Amanda

Hi Tracey

I think the way the spreadsheet is designed at the moment, it doesn't matter how many hours someone is working in a week, it's just recording hour credits and debits and balancing them out by the end of the week.

As a further explanation of what the spreadsheet does:
In column E, the difference is calculated between the actual start/finish time, and the standard start/finish time (subtracting standard start/finish time from actual start/finish time).

In order for the negative hours to show, I changed the date system used in the spreadsheet (Tools - Options - Calculation tab, tick 1904 date system - otherwise negative hours do not show up properly).

In the Running credit/debit total column, the value is F6 is equal to the value in E6 (the number of hours in credit/debit for Monday).

Then in the following cells in column F (F7 to F10), the credit/debit from the previous day (in column F) is taken and then the Hours credit/debit for the current day from column E is added to it.

In F10 I changed the formula slightly as the result came out as a negative result to start off with, so I added in the - sign and the brackets to switch the result from negative to postive.

I hope this helps.
Amanda