How to find lowest and highest time from list?

Question

I have a string list holding time values in this format: 11:25:46.123, I would like to be able to find highest and lowest time value from this list. How can I do it?

I tried something like this, but I am not sure if it is correct and I don't know what to do next.

List<TimeSpan> time = StringList.Select(x => TimeSpan.ParseExact(x, "HH:mm:ss.fff", null)).ToList();

EDIT: I am getting error:

Input string was not in a correct format.

So what is your question? How to get max/min? or how to parse a string list? (as that is what you have an error with). I would suggest editing your question and picking one or the other, not both — musefan, Sep 03 '13 at 09:49
At the beggining my question was about min/max values, but now I see that I have error in prasing! — Michal_LFC, Sep 03 '13 at 09:50

score 7 · Accepted Answer · answered Sep 03 '13 at 09:50

7

I am getting error: Input string was not in a correct format.

Your timespan format is not correct. Try this

var StringList = new[] { "21:25:46.123" };
List<TimeSpan> time = StringList
                      .Select(x => TimeSpan.ParseExact(x, @"hh\:mm\:ss\.fff", null))
                      .ToList();
var max = time.Max();
var min = time.Min();

answered Sep 03 '13 at 09:50

EZI

15,209
2
27
33

3

@musefan try and see. – EZI Sep 03 '13 at 09:52
1

Exactly what I wanted. Working perfectly!! Thank you. :D – Michal_LFC Sep 03 '13 at 09:53
@musefan Why that format ..check this http://stackoverflow.com/questions/12036972/timespan-parseexact-giving-error/12037072#12037072 – V4Vendetta Sep 03 '13 at 10:00
@musefan [Custom format strings for `TimeSpan`](http://msdn.microsoft.com/en-us/library/ee372287.aspx) where introduced in .NET 4.0 (Visual Studio 2010) and are distinct from format strings for `DateTime`. In particular, they don't allow a naked colon, and there is no need to discriminate between `HH` and `hh`. – Jeppe Stig Nielsen Sep 03 '13 at 10:20
2

Note that Linq methods `.Max()` and `.Min()` will throw if the list is empty (for non-nullable types). – Jeppe Stig Nielsen Sep 03 '13 at 10:22

score 4 · Answer 2 · answered Sep 03 '13 at 09:41

4

Have you tried:

TimeSpan maxTimeSpan = time.Max();
TimeSpan minTimeSpan = time.Min();

answered Sep 03 '13 at 09:41

dcastro

66,540
21
145
155

score 4 · Answer 3 · answered Sep 03 '13 at 09:42

4

Try this

TimeSpan _maxtime= time.Max(); // For max time
TimeSpan _mintime= time.Min();// For min time

also take a look at MSDN

answered Sep 03 '13 at 09:42

Rohit

10,056
7
50
82

3

@musefan just to make sure it always remain easy to understand – Rohit Sep 03 '13 at 09:44
3

IMO naming the variable meaningful should be more sufficient than comments – Sriram Sakthivel Sep 03 '13 at 09:45

Ronak Patel · Answer 4 · 2013-09-03T10:06:00.793

2

Try without using ParseExact

List<TimeSpan> times = StringList
    .Select(x => TimeSpan.Parse(x))
    .OrderBy(ts => ts)
    .ToList();
TimeSpan shortest = times.First();
TimeSpan longest = times.Last();

edited Sep 03 '13 at 10:06

answered Sep 03 '13 at 09:49

Ronak Patel

2,570
17
20

or just TimeSpan.Parse(x) – Ronak Patel Sep 03 '13 at 09:49
ya but TimeSpan.Parse(x) should do the job – Ronak Patel Sep 03 '13 at 10:05
You can even get rid of one lambda (anonymous function with `=>`) because you actually "forward" the parameter list from before the arrow, `x`, unaltered to the named method. What I am trying to say is your line 2 can be written `.Select(TimeSpan.Parse)`. – Jeppe Stig Nielsen Sep 03 '13 at 10:27

How to find lowest and highest time from list?

4 Answers4