BENSON
07-11-2007, 04:00 AM
I am working on a shift roster and need help with a formula to determine the following:
A person starts work at 15:00 hrs (3pm) and works untill 23:00 (11pm ),all hours worked after 18:00 ( 6pm) attract a night shift allowance.I can do the formula to give me total Hrs worked but not the formula to tell me how many Hrs worked after 18:00 (6pm)
Any pointers
Thks
A person starts work at 15:00 hrs (3pm) and works untill 23:00 (11pm ),all hours worked after 18:00 ( 6pm) attract a night shift allowance.I can do the formula to give me total Hrs worked but not the formula to tell me how many Hrs worked after 18:00 (6pm)
Any pointers
Thks