Calculating the average time between StartTime and EndTime in VBA or in a calculated control. Then getting an average for many records
I want to get the average time between StartTime and EndTime in VBA or in a calculated control. Then get an average for many records. I am using Access to build controls on a form that will show the average in the form-footer so that when a user changes the form filter the [AvgTimeOnSite] control will add up the [TimeOnSite] controls from above record sets and display an average of minutes that each driver spends at a particular plant when making deliveries.
I am looking to get the average time in minutes that a delivery drivers spend at a particular plant getting loaded or unloaded.
Solution
Use DateDiff("n", ReceivingTime, DepartingTime) to calculate the minutes spent.
Then use Sum and Avg in the form's footer as control sources:
=Sum(DateDiff("n",ReceivingTime,DepartingTime))
=Avg(DateDiff("n",ReceivingTime,DepartingTime))
- Error in odbcConnectAccess2007("BD-Embalses.mdb"). R could not find the function "odbcConnectAccess2007" after installing and loading RODBC
- SQL Learner -- MS Access 2013 ON UPDATE CASCADE and ON DELETE CASCADE
- How to disable access security notice "A Potential security concern has been identified"
- Access VBA MSHTML document with scripts loads slowly
- Populating subform fields from main form field
- Separate column value by space and dash
- Accent-insensitive query in MS Access 2013
- 1 Access Query to Multiple Excel Files Based on Field Value
- Ucase in Access report page header
- Auto scroll to bottom with a textbox
- Trying to use VBA in Access to force string to be a specific Length
- MS Access ADODB.Recordset Cannot Add adLongVarWChar field. Error 3001 Arguments are of Wrong Type
- How can I test and handle a #Func! error from within a query?
- Error on a recordset, but same SQL works elsewhere
- How to extract the schema of an Access (.mdb) database?
- Manipulating an Access database from Java without ODBC
- How to overlap microsoft access - report detail section layout to the previous one to avoid extra rows?
- What can trigger MS Access autoexec vba macro?
- Import recordset from Access to VBA ListBox
- Check if access table exists
- MS Access: There isn't enough memory to perform this operation (Reports)
- How to pass an array to a function in VBA?
- Getting "Too many parameters for command", when calling WinSCP command-line from VBA
- MS-ACCESS Difference between TempVars and TempVar
- Create a MS Access Pivot Query that returns rows even if there are null values
- Microsoft Access SQL is clipping a string when using INSERT to add a record
- Exporting a query result into a text file using vba-MS Access
- VBA referencing external module in .accdb database "tantrum"
- Is there a shorter way of appending information to an existing string?
- How can I automatically update the data in a record when I create a new record in a different table?