C# Time Average

Question

How Can I calculate the average of a given List which content is described below:

Any idea ?!?

In C# with one line of code, don't refrain to post it and we will try to help you if something doesn't work with that... — Adriano Repetti, Dec 04 '15 at 15:49
Convert it to a decimal (whole hours, fractional minutes) and then average that. — Ron Beyer, Dec 04 '15 at 15:50
It's just a list that contains a bunch of hour entries in DateTime format. — jep, Dec 04 '15 at 15:50
Parse them into a TimeSpan. Then find the averages of the total seconds of the TimeSpans. — Fᴀʀʜᴀɴ Aɴᴀᴍ, Dec 04 '15 at 15:52
Yes, neither do I get it. But thanks for taking the time for the detailed solution. — Gustav, Dec 04 '15 at 16:08

score 9 · Answer 1 · answered Dec 04 '15 at 15:54

        var times = new List<string>
        {
            "06:56",
            "06:58",
            "06:55",
            "06:54",
            "06:54",
            "06:53",
            "06:55",
            "06:53",
            "06:58",
            "06:54",
            "06:58",
            "06:55",
            "06:54",
            "06:50",
            "06:54",
            "06:57"
        };
        var average = times
            .Select(TimeSpan.Parse)
            .Average(x => x.TotalMilliseconds);

        var averageTime = TimeSpan.FromMilliseconds(average);

There is a variation here: [Find average of collection of timespans] http://stackoverflow.com/a/8847711/3527297 which averages on the ticks which (though not for the sample data here) may offer a higher precision for subsecond values. — Gustav, Dec 04 '15 at 17:02

Gustav · Answer 2 · 2015-12-04T17:13:44.527

2

Convert the values to TimeSpan. The you can average directly with the output as the correct data type.

Addendum

Adding to the answer from @gabba providing a list of strings and the link above using ticks, you can calculate the average this way:

TimeSpan average = new TimeSpan(Convert.ToInt64(times.Average(x => TimeSpan.Parse(x).Ticks)));

The result value is, of course, the same: 06:54:52.500

edited Dec 04 '15 at 17:13

answered Dec 04 '15 at 15:52

Gustav

53,498
7
29
55

Thank you folks! I'm gonna try something you suggested. – jep Dec 04 '15 at 16:30

C# Time Average

2 Answers2