Elapsed Time Hours and Minutes

[Guest]

I have read through many of the posts but cannot get the correct format.

Subtract time1 from time 2. The result could be minutes or hours. Here is
the query expression

Enroute Time: DateDiff("n",[Call Time DIsp],[Call TIme Enroute]) & "\60" &
Format((DateDiff("n",[Call Time DIsp],[Call TIme Enroute]) Mod 60),"00")

I always get the minutes repeated as hours. A two minute answer will show
up as 2:02.

Any Help would be appreciated.

Don ELston

 

[Guest]

CORRECT EQUATION

Enroute Time: DateDiff("n",[Call Time DIsp],[Call TIme Enroute]) & ":" &
Format((DateDiff("n",[Call Time DIsp],[Call TIme Enroute]) Mod 60),"00")

 

[Marshall Barton]

Enroute Time: DateDiff("n",[Call Time DIsp],[Call TIme Enroute]) & ":" &
Format((DateDiff("n",[Call Time DIsp],[Call TIme Enroute]) Mod 60),"00") []

Subtract time1 from time 2. The result could be minutes or hours. []
I always get the minutes repeated as hours. A two minute answer will show
up as 2:02.

Enroute Time: DateDiff("n", [Call Time DIsp], [Call TIme
Enroute]) \ 60 & Format(DateDiff("n", [Call Time DIsp],
[Call TIme Enroute]) Mod 60, "\:00")

 

[Guest]

Thank You Very Much

Works like a charm

Don

Enroute Time: DateDiff("n",[Call Time DIsp],[Call TIme Enroute]) & ":" &
Format((DateDiff("n",[Call Time DIsp],[Call TIme Enroute]) Mod 60),"00") []

Subtract time1 from time 2. The result could be minutes or hours. []
I always get the minutes repeated as hours. A two minute answer will show
up as 2:02.

Enroute Time: DateDiff("n", [Call Time DIsp], [Call TIme
Enroute]) \ 60 & Format(DateDiff("n", [Call Time DIsp],
[Call TIme Enroute]) Mod 60, "\:00")