seconds into Minutes

[master_student]

Hello Guys,

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

Thanks

[sergio0592]

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

[sunny_talwar]

May be this

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

[Kushal_Chawda]

try this

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

[master_student]

here is an example of a value :48511346498

[balar025]

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?

[effinty2112]

Hi Wiem,

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

Cheers

Andrew