Adding Bank Holiday pay into calculations HELP!

Hi all,

as you are probably aware ive been working on a timesheet for drivers, only ive forgotten to take into account that we have bank holidays and im not sure how to incorporate it in with any of the formulas.

ive put together a small book with the worksheets that require the changes for your help please.

if Col E says Bank Holiday i need the calculations to ignore the pay rate in col S and use the col T instead.

if the company that is worked for that day does not pay overtime after 8 hours then all hours worked will be at the bank holiday rate

if the company does pay over time after 8 hours then it will be first 8 hours at bank holiday rate then after 8 bank holiday rate is *1.5.

this is already done with normal pay but i just need it all incorporated using bank holiday if thats whats selected.

for forum.xlsx

Originally Posted by etaf

Not sure which sheets we are using
Column E on "Agency_Daily_input

in column S and T you have the rates

Sorry , not really following the spreadsheet

What sheet are you updating

you could use a IF statement which adds in the Bankholiday details

the same would need to be done on Agency Daily Input and the Driver FT sheets

Originally Posted by etaf

they are not part of the spreadsheet uploaded

need some scenarios and details with cell references

there are 2 sheets one is called Full Time DI and Agency Daily Input those are the ones that im referring to that need to bank holiday formulas doing on them

Can anyone help pls

Originally Posted by etaf

i still dont know what you are trying to do as requested

Read first post