Hi I have below data in Excel . I want to store this in a Datetime fields 01/04/2022 14:30. col1 col2 col3 13 01/04/2022 14:30 18 02/04/2022 16:00 13 03/04/2022 17:15 Thanks

try this code: DateTime Column2 = DateTime.ParseExact(colum[2].ToString(), "dd/MM/yyyy HH:mm" , System.Globalization.CultureInfo.InvariantCulture); string timeOnly = Column2.ToString( "HH:mm" ); string fullDate = colum[1].ToString() + " " + timeOnly; DateTime StartDate = DateTime.ParseExact(fullDate, "dd/MM/yyyy HH:mm" , System.Globalization.CultureInfo.InvariantCulture);

Use the following code snippet: DateTime Column2 = DateTime.ParseExact(colum[2].ToString(), "dd/MM/yyyy HH:mm" , System.Globalization.CultureInfo.InvariantCulture); string timeOnly = Column2.ToString( "HH:mm" ); string fullDate = colum[1].ToString() + " " + timeOnly; DateTime StartDate = DateTime.ParseExact(fullDate, "dd/MM/yyyy HH:mm" , System.Globalization.CultureInfo.InvariantCulture);