Calcuate Elapse Time

[Guest]

I have one table that track video conference meetings (among other things).
In it I have a StartTime and an EndTime. I want to calcuate the duration of
each meeting. It seems pretty simple, but everything I have found is way to
in depth.

 

[Tom Ellison]

Dear Tom:

See the DateDiff function for details.

Tom Ellison

 

[John Vinson]

I have one table that track video conference meetings (among other things).
In it I have a StartTime and an EndTime. I want to calcuate the duration of
each meeting. It seems pretty simple, but everything I have found is way to
in depth.

In a Query, or as the control source of a form or report textbox, you
can put

TimeElapsed: DateDiff("n", [StartTime], [EndTime])

to get the number of minutes.

John W. Vinson[MVP]