topic Re: seconds into Minutes in QlikView

seconds into Minutes

master_student — Tue, 18 Jul 2017 10:52:01 GMT

Hello Guys,

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

Thanks

Re: seconds into hours

sergio0592 — Tue, 18 Jul 2017 10:54:54 GMT

You can use hour() function with

hour (sum(Stay_Seconds)/86400)

hour ‒ QlikView

Re: seconds into hours

Anil_Babu_Samineni — Tue, 18 Jul 2017 10:55:45 GMT

Will you provide possible values where we need to look

Re: seconds into hours

sunny_talwar — Tue, 18 Jul 2017 11:05:36 GMT

May be this

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

Re: seconds into hours

Kushal_Chawda — Tue, 18 Jul 2017 11:05:53 GMT

try this

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

Re: seconds into hours

master_student — Tue, 18 Jul 2017 11:17:29 GMT

here is an example of a value :48511346498

Re: seconds into hours

balar025 — Tue, 18 Jul 2017 11:27:45 GMT

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')

Re: seconds into hours

sunny_talwar — Tue, 18 Jul 2017 11:28:42 GMT

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

Re: seconds into hours

Anil_Babu_Samineni — Tue, 18 Jul 2017 11:29:41 GMT

Expected hours?

Re: seconds into hours

effinty2112 — Tue, 18 Jul 2017 12:14:19 GMT

Hi Wiem,

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

Cheers

Andrew

Re: seconds into hours

master_student — Wed, 19 Jul 2017 10:47:49 GMT

I would like to convert the result into minutes

Re: seconds into hours

master_student — Wed, 19 Jul 2017 10:48:23 GMT

no minutes

Re: seconds into hours

master_student — Wed, 19 Jul 2017 10:49:26 GMT

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

Re: seconds into hours

Anil_Babu_Samineni — Wed, 19 Jul 2017 10:51:01 GMT

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

Re: seconds into Minutes

master_student — Wed, 19 Jul 2017 10:51:50 GMT

the input is incorrect sorry

Re: seconds into Minutes

Anil_Babu_Samineni — Wed, 19 Jul 2017 10:52:48 GMT

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

Re: seconds into Minutes

Chanty4u — Wed, 19 Jul 2017 10:53:06 GMT

try this

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

Re: seconds into hours

master_student — Wed, 19 Jul 2017 10:54:55 GMT

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

Re: seconds into Minutes

PrashantSangle — Wed, 19 Jul 2017 10:57:22 GMT

Hi,

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

Regards,

Re: seconds into hours

sunny_talwar — Wed, 19 Jul 2017 10:59:41 GMT

How are you getting 40 mins from 4000 seconds?