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
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.
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);
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With