Hi folks,

Happy New Years to everyone.

This is my first post and I am not to bad with excel but trying something new here and need advice to see if what I want is possible.

At my workplace, people receive night shift allowances if they work between 00:00 – 04:00. So for example, if they work 8pm to 5am, they will get extra money for all the hours work.

At the moment, I have a list of people who clock in and out. So in L1, I would see a persons clock in time of 19:00 and in L2, their clock out time of 05:00.

Now as you can see, this person is working between 00:00 and 04:00. How would I go about putting a formula together giving me any sort of indication that he would be eligible to receive a night shift payment.

Sorry if this is confusing at all but please let me know if you require any further information.

Thanks
Pri