Convert minutes into hour and minutes format

[Pitbull]

I'm trying to convert total minutes into hour and minutes format. I have a column of data that contains the difference between two times in minutes. For example, I have the total minutes in one cell as 1460. In the next column, I want to convert 1460 into 24:20. Can anyone tell me how to do this? Please note that I would like to do the minutes calculation and hour and minutes format in the same query. Thanks.

 

[jfgambit]

This will give you the Days, Hours and Minutes based on the Minutes...

Int(([Minutes]\60)\24) & ":" & Format(([Minutes]\60) Mod 24,"00") & ":" & Format([Minutes] Mod 60,"00")