Davebest05
New member
- Local time
- Today, 12:40
- Joined
- Jul 18, 2019
- Messages
- 8
What was the data type of the original data? Was it a date/time field you averaged?I created a query to average it based on the names of the guys on the right.
The format for the data is currently hh:nn:ss
when I use the format function as follows Format([Handle],"hh:nn:ss") it gives me data mismatch type error.
thanks for your help and hope we can fix this . I can post the design details. of query and table.
What was the data type of the original data? Was it a date/time field you averaged?
In the Access table though, after you have moved the data from Excel, what is the data type? Also, when you average it, what is the unit of measure? Is it supposed to represent days, hours, or minutes?actually thinking of it now i realized you are right ..it was date/time.
Hi. If the data is date/time values and you average them, then you will end up having a point in time, wouldn't you? What were those values supposed to represent? Were they supposed to be time durations instead?Date/Time in ms access.
supposed to show minutes seconds or hours minutes seconds in the query and report.
Hi. Just to clarify where I'm coming from, here's an image of a table with a date/time field:Date/Time in ms access.
supposed to show minutes seconds or hours minutes seconds in the query and report.
Hi Dave. It probably works out in your case, but I can't guarantee it does 100%. If the column you're showing in the image is a Date/Time data type, then technically, they don't represent 13 minutes and 27 seconds (for the first row showing 00:13:27). Instead, again if the field is a Date/Time data type, it means 13 minutes and 27 seconds past midnight. So, if the total sum of all the rows does not exceed 24 hours, you might be okay averaging them and just formatting them to display as hours, minutes, and seconds. However, if the total sum of those rows could exceed 24 hours, then you might get inaccurate result.I have attached live data of what I am trying to average. These are in minutes:secdonds...handle time for each technician. I am trying to find the average of these rows. Thanks so so much for your patience.
Dave
not sure how you would average a date - no idea what it means.
Suggest you explain in simple english what you are trying to achieve.
Using the data you provided in your first post - explain the calculation process you need and the expected result from that data
Hi Dave. As I had suspected, your data is about time duration or elapsed time and not points in time. Therefore, I would suggest you do not use a Date/Time data type. If you must include seconds in the data, then I would recommend maybe using the Long Integer data type and store all time duration in number of seconds. You can then do math with these values more accurately and simply format the result to whatever you display format you want/need.This is the situation. I have to report on average amount of time a team of technicians has spent resolving problems .example