Howi can take time duration between start date(10/1/2012 1:00:00 PM) and end date(10/1/2012 3:00:00 PM)
in chart experssion
Look into interval() function in QV.
=interval(TIMESTAMP2 - TIMESTAMP1)
Your timestamps should be interpreted as such, use timestamp#() function if needed, with an appropriate format code.
It helped me Thanks sir.
Thanks for your reply .How i can avoid AM and PM ist come along with duration like (1.00.00 AM) i need 1 hr or 1.30 hr like that
Try like this
=interval(TIMESTAMP2 - TIMESTAMP1,'hh:mm')
Hope it helps
Thanks .its correct Ans.but i have set number style as interval its also working.thanks for your guidence.
Retrieving data ...