1 / 3

Access VBA Jenny Duskey jduskey@accdevjd or jduskey@comcast Phone: 215-884-2959

Access VBA Jenny Duskey jduskey@accdevjd.com or jduskey@comcast.net Phone: 215-884-2959. If you have questions or problems concerning VBA coding or other Access issues in between sessions don’t hesitate to email or phone me. Universal Elapsed Time Functions.

cameran-austin
Download Presentation

Access VBA Jenny Duskey jduskey@accdevjd or jduskey@comcast Phone: 215-884-2959

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Access VBAJenny Duskeyjduskey@accdevjd.com or jduskey@comcast.netPhone: 215-884-2959 If you have questions or problems concerning VBA coding or other Access issues in between sessions don’t hesitate to email or phone me.

  2. Universal Elapsed Time Functions • Format([StartTime] -1 -[EndTime], "Short Time") • Elapsed: DateDiff("n", [StartTime], [EndTime])

  3. How It Works Format([StartTime] -1 -[EndTime], "Short Time"), how does this work? The trick is in the default form of the Access calculator. Any format short time using the minus becomes midnight; hence Format(-1, "short time") becomes midnight Then the system is positional. -1= 24:00- and  1- = 00:00+ (00:00 and 24:00 are the same time (midnight) but different expressions) . #23:00#-1 = 23:00-24:00 =1 and 1-#07:30# = 00.00+07:30 = 7.30 then add  1 + 7:30 = 8:30 Have Fun Robin Stoddart-Ston

More Related