Convert time to number
On Fri, 29 Aug 2008 10:51:00 -0700, Golfinray
wrote:
Use the Datediff command in your query criteria. Datediff("d",[time in],[time
out])
The "d" will give you the answer in days,. If you want it in minutes, I
think it is either m or mm.
Actually "m" is Months; "n" is miNutes.
--
John W. Vinson [MVP]
|