Hi all , i had a requirement where i need to show the share price for the time interval the share traded in the market ,the time has to be my horizontal axis and i have to plot the share price between the start time and end time ,some shares has a time interval with one day and some shares has time interval for 4hrs and some shares have more than one day , what i want to do here is if the trade date is the same say like
in time 4/15/2011 9:00:05
out time 4/15/2011 14:05:02
i have to show the horizontal axis label for every hour (i have data for everyhour),if the trade has more than one day i have to show the horizontal axis label for every 3 hour interval, if trade time more than 3days i have to show the labels in day basis with 12:00 pm as time is it possible to acieve , i know i can do it by DATEDIFF() but i never used it and also tried google no luck can some one please help me out thanks .