Struck up with 5 different pay rates in a day need to seperate the time accourding to rate

Hi Guy's i have struck up in a payroll if any one can help me would be great help full.
I have got a payroll were 24 hour shifts and there are 5 different Pay scales 7-19 one rate 19-22, 22-24, 24-6, 6-7, this are the different times. How do I separate the hours worked between different time without manually calculating.
I am going to attach the excel were the working i have done so u can get more idea & also i have attached a employee time sheet in the excel please help me on this.