Curt,
Well that depends on what you're trying to accomplish.
If you want the number of hours between the two times, you can use:
DateDiff("h", Date1, Date2)
If you want the number of minutes between the two times, you can use:
DateDiff("n", Date1, Date2)
If you want the number of seconds between the two times, you can use:
DateDiff("s", Date1, Date2)
If you want the number of hours, minutes and seconds between the two times,
you can use:
http://www.pacificdb.com.au/MVP/Code/DiffTime.htm
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html