Time-Date chart

[arindam6713]

Dear Experts,

I am trying to plot the end time of a autosys job. Sometimes the job completes at 11:20 pm and sometimes it completes at 1:20 AM.

Data Example:
Date End Time
8/2/2010 11:00 PM
8/3/2010 11:55 PM
8/4/2010 1:23 AM
.
.
.
x/y/z 6:00 AM

That is the max end time of the job.

Now i am trying to plot the data in a graph where on the y axis it will have the time and on the x axis it will have the date. Previously the job used to complete after 12:00 AM so it was not an issue. But now since the job is getting completed before 12:00 AM the chart gets staggered.
If i plot the data then for 11:00 pm the line goes up which shows that the time has increased but actually it has decreased.
So waht i want is if the job ends after 12:00 am then the lien should go up and if the job completes before 12:00 am then the line should come down.
Sample Data :

0:00:00 1/2/2010
23:45:00 1/3/2010
23:55:00 1/4/2010
2:00:00 1/5/2010
1:30:00 1/6/2010
23:20:00 1/7/2010


Thanks in Advance.

[arthurbr]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!