Convert MM to DD:HH:MM

[T1na]

I have got a time which displays in Mins (1590) but would like it to display Days, Hrs and Mins (1 Day, 2 hrs, 30 Mins). How do I change it?

Thanks

 

[lbass]

This is an adaptation of an faq by synapsevampire:

whileprintingrecords;
numberVar dur := {table.minutes};
numbervar days;
numberVar hrs;
numberVar min;
days:= Truncate(dur/60)/24);
hrs := Remainder(Truncate(dur/60),24);
min := Remainder(dur,60);

totext(days,0,"") + " Day"+(if days <> 1 then "s," else ", ")+
totext(hrs,"00") + " Hr"+(if hrs <> 1 then "s," else ", ")+
totext(min,"00")+ " Min"+(if min <> 1 then "s")

-LB

 

[T1na]

Thank you for your help.