The number of timestamps can be solved by adding another row with same date.
I want to split timestamps with different start and end date like the following one
5/11/2012 10:20:00 PM, 5/12/2012 4:00:00 AM
to
5/11/2012 10:20:00 PM, 5/11/2012 11:59:00 PM
5/12/2012 12:00:00 AM, 5/12/2012...
Thanks but there is a misunderstanding by me to your previous question.
The number of timestamps for a particular date is not fixed and timestamp may start on one date and end on another date.
Thanks for the welcome. :)
X axis date and Y axis time.
I can plot the points but I want to connect them as illustrated in the following image in pink color.
http://i.imgur.com/D1Wv2.png
I have two timestamps as shown below. I want to plot date vs. time between timestamps as a chart. Is it possible?
5/10/2012 7:53:00 AM, 5/10/2012 11:41:00 AM
5/11/2012 3:12:00 PM, 5/11/2012 5:59:00 PM
5/11/2012 10:20:00 PM, 5/12/2012 4:00:00 AM