I need to get the values from a column (small example shown on the left) convert them (it "sort-of" represents minutes) from an excel file into a new sql format (on the right) which represents a new incrementing ID (note: single digits always prefixed by '0') and then hours (HH) and then the Minutes(MM) from the far left column. Any ideas?
Field ID/HH:MM
010000D000 (1 mins) 01/00:01
000700D000 (7 mins) 02/00:07
001000D000 (10 mins) 03/00:10
001200D000 (12 mins) 04/00:12
Field ID/HH:MM
010000D000 (1 mins) 01/00:01
000700D000 (7 mins) 02/00:07
001000D000 (10 mins) 03/00:10
001200D000 (12 mins) 04/00:12