C Curt Apr 14, 2004 #1 How do you do a Time diff? for instance Timeout - Timein Thanks for any assistance
G Graham R Seach Apr 14, 2004 #2 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
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
