AutoFill

Hi there,
I need to complete a spreadsheet with lots of different shift patterns and then overtime pattern options for each of the patterns.

There are nearly 1200 different shift patterns due to start times, end times and lengths however a sample are below:
H0700-1100 H0700-1100 (4.00 HRS) 07:00 11:00
H0715-1115 H0715-1115 (4.00 HRS) 07:15 11:15
H0730-1130 H0730-1130 (4.00 HRS) 07:30 11:30
H0745-1145 H0745-1145 (4.00 HRS) 07:45 11:45
H0800-1200 H0800-1200 (4.00 HRS) 08:00 12:00
H0815-1215 H0815-1215 (4.00 HRS) 08:15 12:15
H0830-1230 H0830-1230 (4.00 HRS) 08:30 12:30
H0845-1245 H0845-1245 (4.00 HRS) 08:45 12:45

For each shift pattern I then need three options to capture any overtime worked before or after the shift. Is there a function I can use in Excel to autopopulate this rather than doing this manually?

E.g.
Pattern code Pattern detail Sequence Start End Code
H0700-1100 H0700-1100 (4.00 HRS) 1 07:00 11:00 2001 - Overtime @ 1.00
H0700-1100 H0700-1100 (4.00 HRS) 2 00:00 07:00 1005 - Basic Hours
H0700-1100 H0700-1100 (4.00 HRS) 3 11:00 00:00 2001 - Overtime @ 1.00
H0715-1115 H0715-1115 (4.00 HRS) 1 07:15 11:15 2002 - Overtime @ 1.00
H0715-1115 H0715-1115 (4.00 HRS) 2 00:00 07:15 1006 - Basic Hours
H0715-1115 H0715-1115 (4.00 HRS) 3 11:15 00:00 2002 - Overtime @ 1.00

Many thanks,

Rachel