Solved: Re: seconds into Minutes - Page 2 - Qlik Community

master_student · ‎2017-07-18

Hello Guys,

I have an output in seconds. how to convert it into minutes.

Thanks

master_student · ‎2017-07-19

I would like to convert the result into minutes

master_student · ‎2017-07-19

no minutes

master_student · ‎2017-07-19

there was a mistake in the sql query, the value 48,511,346,498 in incorrcect. I would like to get a result in minutes

Anil_Babu_Samineni · ‎2017-07-19

From this input 48511346498 - What would be the output you want to see in minutes?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

master_student · ‎2017-07-19

the input is incorrect sorry

Anil_Babu_Samineni · ‎2017-07-19

try to explain with sample data set and expected result set ?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Chanty4u · ‎2017-07-19

try this

num(floor([time])/3600,'##.##') as Min,

master_student · ‎2017-07-19

for example my input is in seconds 4000 s => result : 40 min

PrashantSangle · ‎2017-07-19

Hi,

If you get value in sec and you want to convert it into minutes then divide that value by 60 will work.

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 🙂

sunny_talwar · ‎2017-07-19

How are you getting 40 mins from 4000 seconds?