I've tried to search for a solution to this problem but I haven't found one. Please help!!
LOGIC PROBLEM: If an employee's working hours falls between 10:00 pm to 6:00 aM, count no. of hours spent between 10:00 pm to 6:00 am
example
EMPLOYEE | TIME IN | TIME OUT | NIGHT DIFFERENTIAL
Jones, Harry | 10:00 am -10:00 pm
Smith, Paul | 11:00 am - 11:00 pm = 1 ND
Stone, Mark | 2:00 pm - 2:00 am = 4 ND
Philips, Jay | 8:00 pm - 8:00 am= 8 ND (anything over 6 am will not be counted)
Grey, Jean | 9:00 am - 9:00 pm
Ramos, Mary | 10:00 pm - 6:00 am = 8 ND
Thank you so much in advance!!! This will help a lot!
here's all the data above in excel format:
night differential problem.xls
Bookmarks