Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to find an average date/time in the array of DateTime values

Tags:

If I have an array of DateTime values:

List<DateTime> arrayDateTimes; 

What's the way to find the average DateTime among them?

For instance, if I have:

2003-May-21 15:00:00 2003-May-21 19:00:00 2003-May-21 20:00:00 

the average should be:

2003-May-21 18:00:00 
like image 838
c00000fd Avatar asked May 22 '13 04:05

c00000fd


People also ask

How do you find the average of a date?

Calculate average by date in ExcelSelect a blank cell, enter the formula =AVERAGEIF(J2:J24,P2,M2:M24) into it, and press the Enter key. Then you will get the average of the specified date.


1 Answers

If you have large list you can use below method

var count = dates.Count; double temp = 0D; for (int i = 0; i < count; i++) {     temp += dates[i].Ticks / (double)count; } var average = new DateTime((long)temp); 
like image 158
Damith Avatar answered Nov 04 '22 19:11

Damith