Skip to main content
Announcements
April 9th: The AI Roadmap: 6 Landmarks for AI-ready Data and Analytics: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III

seconds into Minutes

Hello Guys,

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

Thanks

1 Solution

Accepted Solutions
sunny_talwar

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

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

View solution in original post

25 Replies
sergio0592
Specialist III

You can use hour() function with

hour (sum(Stay_Seconds)/86400)

hour ‒ QlikView

Anil_Babu_Samineni

Will you provide possible values where we need to look

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
sunny_talwar

May be this

Interval(TimeField, 'h:mm:ss')

Kushal_Chawda

try this

floor(mod(TimeInSeconds,86400) /3600as  Hours,

master_student
Creator III
Author

here is an example of a value :48511346498

balar025
Creator III

IS it number or time object?

if number then you can

vTimeInSeconds = 3700

=Time(MakeTime(floor(vTimeInSeconds/3600),floor(mod(vTimeInSeconds,3600)/60),mod(mod(vTimeInSeconds,3600),60)),'hh:mm:ss')

sunny_talwar

What value do you expect to see once it is converted?

Anil_Babu_Samineni

Expected hours?

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
effinty2112
Master

Hi Wiem,

The example you give (48,511,346,498 seconds) is about 1538 years. When does your calendar start?

Cheers

Andrew