chart experssion time duration

[srinivasa1]

Hi

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

thanks

[swuehl]

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.

[srinivasa1]

It helped me Thanks sir.

[srinivasa1]

Hi

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

thanks

[MayilVahanan · Accepted solution]

HI

Try like this

=interval(TIMESTAMP2 - TIMESTAMP1,'hh:mm')

Hope it helps

[srinivasa1]

Thanks .its correct Ans.but i have set number style as interval its also working.thanks for your guidence.