how to average hours, minutes & seconds in a column

  • Thread starter Thread starter B
  • Start date Start date
B

B

Is there a way to average hours, minutes & seconds in a column?....the
format is : hh:mm:ss

This format CANNOT be changed in the table and there will be 10
records in the "Time" column.

The result will need to be in the hh:mm:ss format....
Thanks for any help you can provide

B
 
This has been answered many times. To perform math, change it to a number
which represents the number of seconds (and tenths and hundreds if desired).
Perform your math, then break the number into whatever format you desire by
using division.

Search using the keyword "duration" and you should find many mnay posts on
this topic.

Rick B
 
Back
Top