Hello,

I am trying to solve a problem that involves a small amount of editing and data manipulation and your help on this would be very much appreciated.

I have time stamps at various intervals, e.g.

01-Jan-13 10:00:06 AM MST TRUE
01-Jan-13 9:00:01 PM MST FALSE
02-Jan-13 10:00:05 AM MST TRUE
02-Jan-13 9:00:05 PM MST FALSE
03-Jan-13 10:00:03 AM MST TRUE

and what I need to do, is produce this data for regular 15 minute intervals, keeping the True or False statement (or using True = 1, False = 0).

To make myself more clear, what I am looking to get is for example:
01/01/2013 10:00 TRUE
01/01/2013 10:15 TRUE
01/01/2013 10:30 TRUE
01/01/2013 10:45 TRUE
01/01/2013 11:00 TRUE
01/01/2013 11:15 TRUE
01/01/2013 11:30 TRUE
01/01/2013 11:45 TRUE
01/01/2013 12:00 TRUE
....
all the way down to....
01/01/2013 21:00 FALSE
01/01/2013 21:15 FALSE
01/01/2013 21:30 FALSE

I have managed to first get rid of the MST, and then produce the cells in a dd/mm/yyyy format. I subsequently found a macro on this website (AddSegment) that will create a timestamp at 15 minute intervals.

However, I am now unsure about how to complete the process.

Any input on this would be fantastic!

Thanks,
Panos