How to convert decimal / number to # of days hours and minutes

[PhineG]

Hi! Would you know the format needed to get the actual days based on a duration value please? The raw data is a number / decimal but everytime I transform / format it using a measure to DD:HH:MM it shows as 30 or 31: Hours: Minutes when days are 0.

It should read 0 days if there is no days involved and show 00:HH:MM. Hope you can help! thanks!

[amitchandak]

@PhineG , Make sure your decimal is in the days. If it is hours divide it by 24 and so on

= time(0,0,0) + [number in days]