How to calculate average time in VB .net
Posted on 2012-08-28
I have an application that loads a dataGridView. One of the columns is a time field in the format HH:MM:SS.
The time data is stored in an SQL server DateTime field and formatted with this line:
DGV1.Columns("Elapsed Time").DefaultCellStyle.Format = "HH:mm:ss"
Now users have requested that I add a label to the form that shows the average elapsed time for all of the rows displayed in the DGV.
How would I do such a thing, I'm not even sure where to start.