Solved: Convert into minutes - 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,

Try with

Interval(.048854166666667,'mm:ss')

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 🙂

View solution in original post

jonathandienst · ‎2016-01-22

Use

Round(.048854166666667 * 1440, 0.01)

1440 is the number of minutes in a day.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

vikasmahajan · ‎2016-01-22

Thanks Jonathan

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,

Try with

Interval(.048854166666667,'mm:ss')

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 🙂

vikasmahajan · ‎2016-01-22

thanks this is giving me exact o/p 70.21

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.

vikasmahajan · ‎2016-01-22

sorry your o/p is 70.35

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.

jonathandienst · ‎2016-01-22

Well you were not very clear about that. Note that interval formats the value as 70:21, but does not change the underlying value, which will still be .04885416...

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

PrashantSangle · ‎2016-01-22

Hi,

As you said

Note that interval formats the value as 70:21, but does not change the underlying value, which will still be .04885416

Kindly can you elaborate?? I am not able to get 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 🙂

swuehl · ‎2016-01-22

Vikas Mahajan wrote:

sorry your o/p is 70.35

Jonathan is calculating a value like 'minutes.fraction of minutes' from your original value, while max dreamer just formats the original value (fractions of day) like 'minutes:seconds'.

What do you want to get? And what do you want to do with this value? Do you want to change the display of the value (i.e. text representation), or do you want to change the numeric value itself?

edit:

Have a look at

Get the Dates Right

Why don’t my dates work?

vikasmahajan · ‎2016-01-22

Thanks for all reply ...

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.

Convert into minutes

Related Topics