topic Conversion of time in QlikView

Conversion of time

Thu, 23 Jul 2015 22:47:53 GMT

Hi,

I have a field in my table "Time_Duration" as EX- '00:00:15' , '00:02:11', '01:12:40'.

I want to calculate duration in seconds like 15 , 131 seconds etc from above format..

Please post your Ideas.

Thanks,

Arun

swuehl — Thu, 23 Jul 2015 23:05:51 GMT

If you want to keep the underlying format, just display as seconds:

=interval( Time_Duration, 'ss')

If you wan to convert the time to a an integer showing seconds:

=num#(interval( Time_Duration, 'ss'))

(Difference will be more relevant when you perform subsequent calculations with the resulting values)

sasiparupudi1 — Fri, 24 Jul 2015 06:28:01 GMT

load Time_Duration ,

interval(Time_Duration,'ss') as Time_DurationSeconds

inline

[

Time_Duration

00:00:15

00:02:11

01:12:40

];

Please close the thread if you got your answer