Hi all ,
i am new to this and struggling with getting excel to split up day and night shifts
day shifts : 9:00-21:00
night shifts : 22:00-09:00
i need excel to recognize and split the hours worked into day and night as some shifts over lap
i have tried a v look up and did not work so i want to try and an if and statement but dont understand how to formulate it
i have attached the work book , sheet one is what i need help with
many thanks in advance
Bookmarks