Hey priyajsr,
Please refer below sample.
Code
C#
private void Form1_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[] { new DataColumn("Working Hours", typeof(string)), new DataColumn("Ot Hours", typeof(string)) });
string str = "0-16:02:04,08:00:00-00:10:35,08:00:00-00:10:19,08:00:00-00:25:58,08:00:00-01:29:01";
string[] strsplit = str.Split(',');
foreach (string item in strsplit)
{
dt.Rows.Add(item.Split('-')[0] == "0" ? "00:00:00" : item.Split('-')[0], item.Split('-')[1]);
}
this.dataGridView1.DataSource = dt;
}
VB.Net
Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
Dim dt As DataTable = New DataTable()
dt.Columns.AddRange(New DataColumn() {New DataColumn("Working Hours", GetType(String)), New DataColumn("Ot Hours", GetType(String))})
Dim str As String = "0-16:02:04,08:00:00-00:10:35,08:00:00-00:10:19,08:00:00-00:25:58,08:00:00-01:29:01"
Dim strsplit As String() = str.Split(","c)
For Each item As String In strsplit
dt.Rows.Add(If(item.Split("-"c)(0) = "0", "00:00:00", item.Split("-"c)(0)), item.Split("-"c)(1))
Next
Me.dataGridView1.DataSource = dt
End Sub
Screenshot
