Date/Time: Calculate differences in time

Please note that the URL for the site has changed from
http://www.mvps.org/access/* to http://access.mvps.org/* format.

Home | French | About | Search | mvps.org


	What's New Table Of Contents Credits Netiquette 10 Commandments Bugs Tables Queries Forms Reports Modules APIs Strings Date/Time General Downloads Resources Search Feedback mvps.org FAQs In Memoriam Terms of Use

Date/Time: Calculate differences in time	Author(s)
	Terry Kreft


You can use the following logic to calculate the difference between two times which works even across midnight. Format([StartTime] -1 -[EndTime], "Short Time")