Separating multiple values from single column using C#

See more:

SQL-Server

C#3.5

I am trying to import Excel sheet into sql server database. My excel sheet contains attendance details of employees where fields are: Emp_code,Emp_nm,Work_hrs,Time
Here at Time column both in_time and out_time is combined that is both In_time and out_time are in single column "Time" separated with white space.
I wanted to separate these timing using code(c#) . that is when i import the file before putting it in database the timing must be separated.

Database structure: Emp_code,Emp_nm,Work_hrs,In_time,Out_time

So please, could anybody help me with that.

Thank you.

What I have tried:

I have tried separating the values using split but its not working