topic Re: How to convert seconds in to DD:HH:MM:SS format in QlikView

How to convert seconds in to DD:HH:MM:SS format

SatyaPaleti — Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

How can we convert seconds in to DD:HH:SS format

for example I am having 20400062 seconds. How can we show this in to Days Hours Minutes seconds format DD:HH:MM:SS

Could you please help on this

Thanks and Regards,

Satya

Re: How to convert seconds in to DD:HH:MM:SS format

prma7799 — Tue, 24 Oct 2017 06:20:12 GMT

try like this

Convert Seconds into Hours | Qlik Community

Re: How to convert seconds in to DD:HH:MM:SS format

SatyaPaleti — Tue, 24 Oct 2017 06:28:18 GMT

Thank you. But I require in days

Re: How to convert seconds in to DD:HH:MM:SS format

prma7799 — Tue, 24 Oct 2017 06:31:49 GMT

try like this;

secondsfeild/360 this will convert hrs

Days conversion:

(secondsfeild/360)/8 as days

Re: How to convert seconds in to DD:HH:MM:SS format

tresB — Tue, 24 Oct 2017 06:35:23 GMT

Try like:

=Floor(20400062/60/60/24) &' Days ' & Interval(frac(20400062/60/60/24),'hh:mm:ss')

Re: How to convert seconds in to DD:HH:MM:SS format

pradosh_thakur — Tue, 24 Oct 2017 06:36:01 GMT

try this

=Interval([time_field]/86400,'DD:hh:mm:ss')

=Interval(20400062/86400,'DD:hh:mm:ss')

Re: How to convert seconds in to DD:HH:MM:SS format

Anonymous — Tue, 24 Oct 2017 06:59:31 GMT

HI,

I have used following expression to get DD:HH:MM:ss format

its worked fine

=timestamp(20400062,'DD:HH:MM:ss')

Regards

Sahadev

Re: How to convert seconds in to DD:HH:MM:SS format

SatyaPaleti — Tue, 24 Oct 2017 19:24:17 GMT

Thank you so much Mahadev

I have a requirement. the above number(20400062) I have shown is in Minutes I want to convert Minutes in to Days. But day have only 8 hours. How can we do this

Re: How to convert seconds in to DD:HH:MM:SS format

SatyaPaleti — Tue, 24 Oct 2017 19:25:02 GMT

Thank you so much Thakur

I have a requirement. the above number(20400062) I have shown is in Minutes I want to convert Minutes in to Days. But day have only 8 hours. How can we do this

Re: How to convert seconds in to DD:HH:MM:SS format

vishsaggi — Tue, 24 Oct 2017 19:30:12 GMT

Did you try Tresco's expression like

just changed 24 to 8 hours.

=Floor(20400062/60/60/8)

Re: How to convert seconds in to DD:HH:MM:SS format

SatyaPaleti — Tue, 24 Oct 2017 19:34:05 GMT

Thank you so much Tresco

I have a requirement. the above number(20400062) I have shown is in Minutes I want to convert Minutes in to Days. But day have only 8 hours. How can we do this

Re: How to convert seconds in to DD:HH:MM:SS format

SatyaPaleti — Tue, 24 Oct 2017 19:35:53 GMT

No Viswanath. I tried it. It's working fine

Re: How to convert seconds in to DD:HH:MM:SS format

SatyaPaleti — Tue, 24 Oct 2017 19:40:13 GMT

Vishwanath I have Tried this. But in some cases it's not working much

=Floor(180/60/60/24) &' Days ' & Interval(frac(180/60/60/24),'hh:mm:ss'). Iam getting out put 0 days 00:03:00.

Is it 0 days 3 Mins

Re: How to convert seconds in to DD:HH:MM:SS format

SatyaPaleti — Tue, 24 Oct 2017 19:41:05 GMT

Can you please modify the formula if any change required

Re: How to convert seconds in to DD:HH:MM:SS format

SatyaPaleti — Tue, 24 Oct 2017 19:44:40 GMT

=Floor(1500/60/60/24) &' Days ' & Interval(frac(1500/60/60/24),'hh:mm:ss')

Out put is 0 days 00:25:00 but in this case out put should be 3 days 1 hour

Re: How to convert seconds in to DD:HH:MM:SS format

sunny_talwar — Tue, 24 Oct 2017 19:49:38 GMT

Try this

=Floor(1500/60/8) & ' Days ' & Interval(Frac(1500/60/8)/3, 'h') & ' hours ' & Num(SubField(Interval(Frac(1500/60/8)/3, 'h:mm'), ':', -1)) & ' minutes'

Re: How to convert seconds in to DD:HH:MM:SS format

vishsaggi — Tue, 24 Oct 2017 19:53:02 GMT

Yes bcoz your minutes are lesser may be try this? Fieldname here is your actual field where you have these mintures.

= IF(Fieldname < 3600, Interval(Fieldname/60/24, 'd hh:mm:ss'), Interval(Fieldname/60/60/24, 'd hh:mm:ss'))

Re: How to convert seconds in to DD:HH:MM:SS format

SatyaPaleti — Tue, 24 Oct 2017 20:00:13 GMT

Thank you Sunny

Re: How to convert seconds in to DD:HH:MM:SS format

SatyaPaleti — Tue, 24 Oct 2017 20:00:34 GMT

I will try it Viswanath. Thank you for help

Re: How to convert seconds in to DD:HH:MM:SS format

pradosh_thakur — Wed, 25 Oct 2017 07:13:08 GMT

Hi Ppaleti

go through this thread

https://community.qlikview.com/thread/150930

hopefully it will help.

regards

Pradosh