Solved: Convert into minutes - Page 2 - Qlik Community

vikasmahajan · ‎2016-01-22

Hi Team

I have data like this

=Timestamp( .048854166666667,' hh:mm:ss')

o/p is 1:10:21

I want to convert this into minutes 60+10+.21 = 70.21 minutes how to achieve the same.

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

PrashantSangle · ‎2016-01-22

Hi,

Now I am more curious about it.

Dear Mr. jontydkpi‌ / Mr. swuehl‌

Please please explain me about it , If possible with example.

I am newbie for this .

Regards,

Prashant

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

swuehl · ‎2016-01-22

Well, you need to understand the concept of a DUAL value:

Data Types in QlikView

Then continue reading about formatting and interpretation functions, like num() vs. num#(), Date() vs Date#(), Interval() vs. Interval#() etc.

See the links in my previous post (and keep on reading the referenced links therein).

PrashantSangle · ‎2016-01-22

Hi,

Thanks for reference link but still I have some stupid question in my mind, but before asking that question better I will read those article and then come back with it .

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Convert into minutes

Related Topics