that's my typo C04 shoould be included

the output should be

5 c05

6 c06

3 C03

1 C01

4 C04

2 C02

not

5 c05

6 c06

1 c01

3 c03

4 c04

2 c02

gentleman thx for the code but here is my approach

composed a udf that returns the csv

DECLARE @StartTime TIME(0) = '00:10'

DECLARE @EndTime TIME(0) = '01:40'

DECLARE @MinutesToAdd INT = 5

DECLARE @RunningTime TIME(0)='00:10'

Declare...