Hours & Minutes Data

Jagjit Saini

I have below excel sheet . In third column i have Hr & Min nut it show Dates also with it when i Upload Data

String Time = colum[2].ToString();

Below is the Excel Data

Col1 Col2 Col3

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Muhammad Imran Ansari4y ago
Accepted answer
Check the cell format in excel, wheather its custom or time only? But you can manipulate while uploading like:
DateTime fullDate = DateTime.ParseExact("31/12/1899 14:30", "dd/MM/yyyy HH:mm", System.Globalization.CultureInfo.InvariantCulture);
string timeOnly = fullDate.ToString("HH:mm");
timeOnly will will only time part.
Jagjit Saini4y ago
Hi Sachin

Same error on below line
DateTime dateTime = DateTime.ParseExact(colum[2].ToString(), "HH:mm", System.Globalization.CultureInfo.InvariantCulture);
Thanks
Sachin Singh4y ago
try this

DateTime dateTime = DateTime.ParseExact(colum[2].ToString(), "HH:mm", CultureInfo.InvariantCulture);
Jagjit Saini4y ago
Hi Sachin

It gives error on this line . Input string not in correct format

DateTime fullDate = DateTime.ParseExact(Time, "dd/MM/yyyy HH:mm", System.Globalization.CultureInfo.InvariantCulture);

Thanks

You can also use


string timeOnly = fullDate.ToShortTimeString();