Hours & Minutes Data

Question

Hi

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

13	01/04/2022	14:30
18	02/04/2022	16:00
13	03/04/2022	17:15

Muhammad Imran Ansari · 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 Saini · Answer

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

Sachin Singh · Answer

try this DateTime dateTime = DateTime.ParseExact(colum[2].ToString(), "HH:mm", CultureInfo.InvariantCulture);

Jagjit Saini · Answer

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

Sachin Singh · Answer

You can also use string timeOnly = fullDate.ToShortTimeString();

Jagjit Saini · Answer

Hi Muhammad In Excel it is entered as 14:30 but when uploaded in variable Time it shows as - 31/12/1899 14:30:00 I have written like below now String Time = colum[2].ToString(); DateTime fullDate = DateTime.ParseExact(Time, "dd/MM/yyyy HH:mm", System.Globalization.CultureInfo.InvariantCulture); string timeOnly = fullDate.ToString("HH:mm"); Below is Excel Data col1 col2 col3 13 01/04/2022 14:30 18 02/04/2022 16:00 13 03/04/2022 17:15 Thanks

Hours & Minutes Data

Answers (6)