Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III
‎2017-07-18 06:52 AM

seconds into Minutes

Hello Guys,

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

Thanks

Labels (1)
Labels
6,513 Views
0 Likes
25 Replies
master_student
Creator III
Creator III
‎2017-07-19 07:01 AM
Author

In response to sunny_talwar

no i am just trying to explain

1,285 Views
0 Likes
Anil_Babu_Samineni
MVP
MVP
‎2017-07-19 07:01 AM

In response to master_student

Even, Question not clear. I am sorry

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
1,285 Views
0 Likes
master_student
Creator III
Creator III
‎2017-07-19 07:02 AM
Author

In response to PrashantSangle

the result will be with comma

1,285 Views
0 Likes
sunny_talwar
MVP
MVP
‎2017-07-19 07:03 AM

In response to master_student

So convert 2400 seconds to 40 mins? Is this what you want to do?

Interval(Interval#(SecondsField, 's'), 'm') as Minutes

5,165 Views
PrashantSangle
MVP
MVP
‎2017-07-19 07:21 AM

In response to master_student

Can you explain little bit more

For example if your input is 4200 sec then what is your expected output???

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 🙂
1,285 Views
0 Likes
Uri
Creator
Creator
‎2020-07-31 11:41 AM

This helped me:

=Interval(Interval#([Voice(MIN)], 's'), 'hh:mm:ss')

1,199 Views