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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Averaging Hourly Data 2
Averaging Time 1
Average hours/minutes 4
Averaging all values for each hour??? 11
Converting Seconds to Hours, Minutes, Seconds 3
Calculating Hours, Minutes and Seconds 6
Sum of minutes and seconds times price? 2
hours, minutes, seconds 4

Back
Top