Format Of Time Difference

[Wayne]

I'm trying to express the difference between two Date/Time fields as
Hours:Minutes in the query grid by using:

MoveTime: DateDiff("h",[MoveFrom],[MoveTo]) & ":" & (DateDiff("n",
[MoveFrom],[MoveTo]) Mod 60)

This almost works except a difference of 2 hours and 7 minutes
displays as "2:7" instead of "2:07". Is there a way that I can force
the query to display the required format?

Any help is appreciated.

[Allen Browne]

Try:
MoveTime: DateDiff("h",[MoveFrom], [MoveTo]) &
Format(DateDiff("n", [MoveFrom], [MoveTo]) Mod 60, "\:00")

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Wayne" <cq*******@volcanomail.comwrote in message
news:11*********************@l53g2000cwa.googlegro ups.com...

I'm trying to express the difference between two Date/Time fields as
Hours:Minutes in the query grid by using:

MoveTime: DateDiff("h",[MoveFrom],[MoveTo]) & ":" & (DateDiff("n",
[MoveFrom],[MoveTo]) Mod 60)

This almost works except a difference of 2 hours and 7 minutes
displays as "2:7" instead of "2:07". Is there a way that I can force
the query to display the required format?

Any help is appreciated.

[Wayne]

Thanks Allen. It works perfectly.