Datediff function (Display hours and minutes)

[Steve]

Hi
I am using the datediff funcion and get the result
displayed in minutes and convert to hours and minutes.

70 minutes is displayed a 110

I would like it to diplay as 1:10 or 1 hour 10 mins.

I tried to use[duration]\60 & Format([duration] MOD
60,":00") but this will only display hours.

Any ideas, cheers Steve

 

[Van T. Dinh]

Try:

[Mins] \ 60 & ":" & Format$([Mins] MOD 60, "00")