in cell A1 : 26-08-2016 05:00:00 AM In cell A2 : 26-08-2016 10:00:00 AM we required starting time to ending time with a fixed interval like 00:15 or 00:30 or 01:00 Suppose for 01:00 hr interval we required in another sheet A1: 05:00 A2: 06:00 A3: 07:00 A4: 08:00 A5: 09:00 A6: 10:00 Suppose for 00:30 hr interval A1: 05:00 A2: 05:30 A3: 06:00 A4: 06:30 A5: 07:00 A6: 07:30 A7: 08:00 A8: 08:30 A9:09:00 A10:09:30 A11:10:00
