Hi,
I am doing a spreadsheet to calculate my hours worked and my pay. I have everything done that I need, but for one thing, I usually work 19:00 to 07:00, calculating these hours was no problem, however, I am paid a supplement between the hours of 18:00 to 06:00, so I only get this for 11 of the 12 hours worked. My question is, how do I get the spreadsheet to count how many of my worked hours fall in the unsociable hours time frame? So in one column I have my total hours and in another column I have a total of unsociable hours. Hope that all makes sense!
Cheers
Gavin
Bookmarks