time lapsed how to calculate

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

Guest

I maintain log book for volunteers. Have form that stores in table who the
volunteer is, their starting time and ending time. Time fields are lookups
to other tables with values @ 15 minute increments. How do I calculate the
amount of time that has lapsed between their ending and starting times?
 
On Mon, 4 Oct 2004 09:47:07 -0700, Rusty of Julian <Rusty of
How do I calculate the
amount of time that has lapsed between their ending and starting times?
Click to expand...

If they are Date/Time fields, use

Lapsed: DateDiff("n", [Start], [End])

If they're lookup fields (yuck!) in some other datatype, please
expliain what's actually stored in your table. Be aware that a Lookup
Field conceals the actual contents of your table - usually a
meaningless numeric ID - behind the "lookup".

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top