Calcuate Elapse Time

T

Tom G

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.
 
J

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.
Click to expand...

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]
 
Top