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
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.
I am performing a simply date subtract in a query
Code:
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.