Recent content by Davebest05

This is the situation. I have to report on average amount of time a team of technicians has spent resolving problems .example Technician Time - Taken Team-Name Tim 13min 45 sec A Tom 8 min 30 sec A Jay 10min 9 sec B Bill 11min 18sec...

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

Date/Time in ms access. supposed to show minutes seconds or hours minutes seconds in the query and report.

actually thinking of it now i realized you are right ..it was date/time.

originally imported into access database as text from ms excel . After importing I changed the format. Thank you .

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...

The attachment shows the results of a query I am getting. I need to format the handle time column so that it shows hh:nn:ss format. cant get it for the life of me.

newbie looking to learn and ask a lot of questions :)