How can we convert Minutes in to DD:HH:MM:SS format Day has only 8 hours

[SatyaPaleti]

Hi Folks,

How can we convert Minutes in to DD:HH:MM:SS format

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

Could you please help on this. I

Thanks and Regards,

Satya

[sunny_talwar]

May be this

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

[sunny_talwar]

I am getting 42500 days 1 hour and 2 minutes... is this what you were looking to get?

[SatyaPaleti]

Thank you Sunny. This is what I am looking for

[SatyaPaleti]

Hi Sunny,

I have one more requirement on this. I have to use this Expression in bar chart but it's giving me a error when I am using this in expression. This is because of strings we are using 'Days','Hours' & 'Minutes'. How can we show strings in this case

Currently In bar chart I am getting  13478:7:18 but it have to show 13478 Days 7 Hour 18 minutes. How can we write this in Bar chart Expression

I am attaching sample data and sample qvw also could you please help on this

In expression I am using this

!=Floor(sum(Duration)/60/8) &':'& Interval(Frac(sum(Duration)/60/8)/3, 'h') & ':' &

Num(SubField(Interval(Frac(sum(Duration)/60/8)/3, 'h:mm'), ':', -1))

Thanks and Regards,

Satya

[SatyaPaleti]

Hi Sunny,

Can you please look in to below issue this what i have explained in the above Issue

How can we use Strings in Bar Chart Expression

Thanks and Regards,

Satya

[tresesco]

Check it here:Re: How can we use Strings in Bar Chart Expression