I would suggest you to create a new universe object that would calculate this for you.
However if you need a report-level solution then the conversion from the number of minutes to days, hours and minutes should use this formula:
=FormatNumber(Floor([number of minutes] /1440) ;"0") + " days, " +
FormatNumber(Floor(Mod([number of minutes] ;1440)/60) ;"0") + " hours, " +
FormatNumber(Mod(Mod([number of minutes] ;1440) ;60) ;"0") + " minutes"
It would be more complicated formula (if possible at all) for the conversion that would display also the number of months/years - the reason is the varying number of days in months. So without knowing either the start date or the end date you are not able to say whether 4000 minutes are from February to April or from March to May…
I am new crystal reports…I have got the same problem…want to convert the days in to days:hours:minutes format.I saw your formula.But i could not understand.Please can you explain me how to use the formula in crystal reports.