topic Re: Time format in QlikView

Time format

Tue, 26 Nov 2013 06:05:12 GMT

I want certain format to get difference in two times in total hours: minutes and seconds

Like in attached picture of excel format

agni_gold — Tue, 26 Nov 2013 06:07:52 GMT

What you hava , Timestamp or only time ?

Tue, 26 Nov 2013 06:10:54 GMT

time!

look at the picture attached

its 37hours:30minutes:55seconds

er_mohit — Tue, 26 Nov 2013 06:11:20 GMT

you must know the format of time field

then use interval function like this

interval(timefield1- timefield2,'hh:mm:ss')

here for both timefield format should be same if don't then before interval function use timestamp# function

Tue, 26 Nov 2013 06:14:01 GMT

Try Date(Field,’hh:mm:ss’)

Tue, 26 Nov 2013 06:16:31 GMT

offcourse that would not work!

date is not required

Tue, 26 Nov 2013 06:17:48 GMT

Try this hope it will help

=interval(time1-time2,'hh:mm:ss')

Tue, 26 Nov 2013 06:34:20 GMT

Try this

=Interval(Timestamp#('26-11-2013 02:15 PM','DD-MM-YYYY hh:mm TT')-Timestamp#('24-11-2013 01:30:30 PM','DD-MM-YYYY hh:mm:ss TT'),'hh:mm:ss')

Here first time field need to be greater the second time field other wise u will get the minus value.