I would like to request Experts help create a VBA code to convert all data starts with "24 to 30" at Column A (Source sheet) into 00 to 06.
E.g. Data at cell A253 (24:19:02.00) become 00:19:02.00, data at Cell A300 (26:10:00.00) converted into 02:10:00.00, and data at cell A349 (29:52:21.00) become 05:52:21.00.
Hope Experts could help me create this feature. Attached the workbook for Experts perusal.