DateDiff

[ROB]

I have a problem trying to display the hours and mins in the same field. I can get it to display the hour and the mins difference. What is the solution, at present I have DiffHours"h",[DateFrom],[DateTo]) It only displays the hour not the minutes difference eg 13:45 TO 15:10 ONLY SHOWS 1 HOUR NOT 1 HOUR 25 MINS

[LillMcGill]

Calculate Minutes... Minutes: DateDiff("n",[date1],[date2])

Then get hours and minutes from that...Expr1: [Minutes]/60 & Format([Minutes] Mod 60,"\:00")

[ROB]

Thank you very much problem solved