Incident Rule

Incident Rule

Hi,

I have the query below which return a value in minutes. Is there a way i can get the result in DD:HH:MI (Days, Hours, Minutes) ?

workitem(workitem_comment)
[color=blue]-------------------------------------[/color]
Time to resolution=HDQUERY[[select DATEDIFF(mi,[workitem_created_on],[workitem_modified_on]) From [Workitem_Current_View] where workitem_number=WORKITEM(workitem_number)]] minutes

I've tried changing where it says MI to HH12:MI but that didnt work....