Calcuate Elapse Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

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