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?
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?
Hi. Just to clarify where I'm coming from, here's an image of a table with a date/time field:
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.
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.
