Is there ANY way of getting the Excel spreadsheet to add up each colour coded cell for each row. eg. Add all the Yellow cells together
For the last three months everyone at our company has been getting short-paid on their overtime because the people in the HR department who USED TO do the adding up have left and their replacements STILL are not doing it right despite having been told TWICE before that they are doing it wrong.
NOW people are saying that they WONT do any more overtime until the company does something about it and pays them what they are owed.
One of the problems with the spreadsheet is the numbering across the top - Why do they start it at the 28th when it would make more sense to start from the 16th of the previous month when the spreadsheet gets emailed to HR.
NONE of the overtime from 16th to the 27th has been paid to anyone in the company. The company's first response was "It's not on the spreadsheet" - of course it is not ON the spreadsheet you pillocks because the managers enter it on the previous months spreadsheet which has already been passed to HR. So technically the spreadsheet runs from 28th through to 27th. But only the figures up to the 15th are actually handed in.
The company conveniently forgets to add the last week of the previous month that we have worked and haven't been paid for.
They NEVER add on what they missed out the previous month either - at least I can't see an extra payment on my payslip anywhere so I assume they haven't bloody paid it.
One colleague sat down and worked out that to date she is owed about £200 worth of Overtime from these mistakes over the last four months. Over the course of a year the amount is astronomical.
Can ANYONE help us with a solution to this spreadsheet problem. Other than murdering the HR department that is.