spreadsheet guru wanted to create - just the basics- nothing fancy please help

dreadz123

Newbie
so i'm looking for a guru to help create a spreadsheet that entails the hourly rate the nhs worker is on, then inputting the date of a shift worked- alongside the start and finish times of that shift. then totalling the hours worked- but heres the key bit -All time on Saturday (midnight to midnight) and any week day after 8 pm and before 6 am -accrues Time plus 30%. -All time on Sundays and Public Holidays (midnight to midnight) -accrues Time plus 60%. - column thats states the enhanced bit?
i've tried and tried to get around this but unscuccesful- you'll be helping out a fellow nhs worker- always good :P
 
I’m pretty good but my m8 is a guru as you call him I will ask him for you.

What’s the hourly rate.
 
Back
Top