topic Re: Time arythmetic in QlikView

Time arythmetic

Fri, 18 Oct 2013 16:00:54 GMT

Hello,

Im currently trying to add/substract time format.

The fields are like '06:00:00 AM' , '14:00:00 PM', etc.

When i do just like time1 - time2 it returns decimals.

I was wondering if anyone knows a way to transform those decimals to a similar time format?

thanks,

Re: Time arythmetic

Gysbert_Wassenaar — Fri, 18 Oct 2013 16:07:03 GMT

Times are fractions of a day, so decimals would be a logical result. You probably only need to format the result as a time. Interval(Time1 - Time2, 'hh:mm:ss').

Re: Time arythmetic

jagan — Fri, 18 Oct 2013 16:17:19 GMT

Hi,

Try like this

=Interval(Timestamp(Timestamp#('06:00:00 AM', 'hh:mm:ss TT')) - Timestamp(Timestamp#('14:00:00 PM', 'hh:mm:ss TT')), 'hh')

Returns -8 in hours.

Hope this helps you.

Regards,

Jagan.

Re: Time arythmetic

Fri, 18 Oct 2013 16:19:54 GMT

thank you )))

Re: Time arythmetic

jagan — Fri, 18 Oct 2013 16:23:11 GMT

Hi,

Please close the discussion by giving correct and helpful answers to the posts which are useful to you.. It helps others to find answers to similar type of scenarios.

Regards,

Jagan.