In short I am totally stuck!
I am required to produce a spreadsheet that works out the pay of workers,
where upto 35 hours a week is paid at normal salary,
36 - 40 hours a week is paid at time and a half and where
41+ hours a week is paid at double time.
Can this be sorted out with just the information given as the hours worked?
I'm sure that there is a function in excel that can work this out but i am baffled.
For example, if a person works 39 hours, they will get paid 1 - 35 hours at normal salary and 4 hours at 1.5 salary, and at £5 an hour would receive £205 (i think). And I would like this to be done in one formula! Is this possible?
I would like this to be done automatically!
Any help (Gandalf?) would be received very gratefully.