I need some help with a formula which will check to see if the start time and finished time is between 22:00 - 06:00. which is unsocial hours which is 20% more on the hourly rate.
Example start at 20:00 and finish at 08:00 the next day which will be 8 hours unsocial and 12 hours worked
thanks
Bookmarks