Calculate Day and time

[rakeshkumar1890]

how can convert 23142 into day and time

[rakeshkumar1890]

Thanks for the solution

It was

Interval(23142/(24*60),'dd:hh:mm:ss')

Because Number was in minutes

Thank you so much all of your inputs.

[pradosh_thakur]

If the number was in minutes you wont get the answer as 06:25:42 . Anyways please close the thread by marking answer correct and helpful.

[MarcoWedel]

Hi,

another solution to this might be:

Interval(Interval#(Minutes,'m'),'dd:hh:mm:ss')

hope this helps

regards

Marco