Hi,
Been racking my brain for a while now trying to figure this out...I'm close to giving up - my Excel skills aren't what they used to be!
I'm looking to create a sheet which documents the hours I've worked, keeping record of any overtime, etc. As a shift worker I qualify for an unsociable hours payment between 20:00 and 06:00 and I'm looking to calculate this automatically.
i.e. data input is start and finish time, output is total number of hours worked and hours worked between 20:00 and 06:00
e.g. 07:00 -16:00 = 9 hours worked, 0 unsociable hours; 15:00 - 00:00 = 9 hours worked, 4 unsociable hours; 22:00 - 07:00 = 9 hours worked, 8 unsociable hours.
I hope this makes sense - any help gratefully appreciated!
Bookmarks