• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to plot date vs. time between timestamps?

T

Tamil

New Member
I have two timestamps as shown below. I want to plot date vs. time between timestamps as a chart. Is it possible?

[pre]
Code: 
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
[/pre]
 
Tamil


Firstly, Welcome to the Chandoo.org Forums


Can you be more specific and maybe give us an example of what values should go on the X and Y axis ?
 
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
 
Hi tamil,


How many times these "time stamps" will appear for a single data?? Just twice or more then that?? I started working over that but stuck and stopped, need your reply.


Regards,

Faseeh
 
Tamil,


Please see this one:


http://dl.dropbox.com/u/60644346/Tamil_timestamps.xlsx


Regards,

Faseeh
 
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.
 
Hi Tamil,


A single time stamp crossing over multiple dates?? Can i have the max. no. for this thing any guess perheps?? Neither your data nor the uploaded sample pic had such thing. OK Let me give it a try. Consider it doing like a gantt chart??


Regards,
 
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


Code: 
5/11/2012 10:20:00 PM, 5/12/2012 4:00:00 AM


to

[pre]5/11/2012 10:20:00 PM, 5/11/2012 11:59:00 PM
5/12/2012 12:00:00 AM, 5/12/2012 4:00:00 AM
[/pre]
Any ideas?
 
Hi Tamil,


The shape in which you have presented data is really difficult to plot, added to that is that you do not know how much time time stamps are to be repeated so its really difficult. Might some one write a macro for you then it could be solved.


Regards,

Faseeh
 
I wrote a code to split the timestamps with different start & end date and then plotted it as Gantt chart.


Thank you very much for helping. :)
 
Hi Tamil,


I once thought about gantt charts, but you wanted to plot it vertically so i dropped the idea. Any ways you are welcome any time. :)


Regards,

Faseeh
 
You must log in or register to reply here.
Back
Top