Subtracting date and time

[Carl_R]

I've almost got this but seem to be a little stuck on the format part.

I am performing a simply date subtract in a query

Test: Format([OpenedDateTime]-1-[ClosedDateTime],"h,nn")

I am trying to format the result in hours and minutes - so 19/05/2008 09:10 - 21/05/2008 15:17 = 54:07

Any suggestions welcome.

 

[RodgerDJr]

You want to use DateDiff

DateDiff("n",[OpenedDateTime],[ClosedDateTime])

This will give it to you in minutes.

 

[Carl_R]

Perfect. I have used "h" to get the rounded hours