I have a sheet as ARE Raw which has all the records in it. This has the skill number in a half hourly interval.
I have the list of records as Skill number in a column C. and in total there are 119 unique skill numbers.
I am not sure is there a code as it will take Max and Min time from the raw report ARE Raw sheet and will create a sheet which will have all the 119 unqiue skill number with half hourly interval a as 0:00 to 23:30 is the time.
ref the table below
I have the list of records as Skill number in a column C. and in total there are 119 unique skill numbers.
I am not sure is there a code as it will take Max and Min time from the raw report ARE Raw sheet and will create a sheet which will have all the 119 unqiue skill number with half hourly interval a as 0:00 to 23:30 is the time.
ref the table below
SkillNum | Time |
2100 | 0:00 |
2100 | 0:30 |
2100 | 1:00 |
2100 | 1:30 |
2100 | 2:00 |
2100 | 2:30 |
2101 | 0:00 |
2101 | 0:30 |
2101 | 1:00 |
2101 | 1:30 |
2101 | 2:00 |
2101 | 2:30 |
2101 | 3:00 |
2101 | 3:30 |
2102 | 0:00 |
2102 | 0:30 |
2102 | 1:00 |
2102 | 1:30 |
2102 | 2:00 |
2102 | 2:30 |
2102 | 3:00 |
2102 | 3:30 |
2103 | 0:00 |
2103 | 0:30 |
2103 | 1:00 |
2103 | 1:30 |
2103 | 2:00 |