how to convert the Interval hh.mm.ss in day format

[pascos88]

Hello,

I have the interval 26.05.00 that now means 26 hours 05 minutes and 00 second.

I would like change the format in days, so the result of the same interval should be 01.02.05 that it will means 01 day 02 hours and 00 minutes.

Someone can help me with a function?

Regards

[pascos88]

Anyway the interval is it not fixed, it is the result of a Sum.

[settu_periasamy]

Try this

=Interval(Interval#('26:05:00','hh:mm:ss'),'dd:hh:mm')

Edit:

changed 'MM' to 'mm. Because 'MM' denotes Month

[pascos88]

Hello,

really thanks for the replay.

Can you advice me how I can write this function with a Sum.

So my intervall is calculated by a Sum(Time) (inside a Definition of the Expression) and I check intervall in Number format.

I am not sure how I can write it in Definition...

Regards

[maxgro]

go to number tab, choose interval and use the format pattern

dd:hh:mm

[settu_periasamy]

May be Like this..

=sum(Interval(Interval#(Time,'hh.mm.ss'),'dd.hh.mm'))