Please refer this
HTML
<div>
Time Difference for employee Id: 1
<asp:Label ID="lblTimeDifference" Text="" runat="server" />
</div>
Namespaces
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
using System.Globalization;
C#
protected void Page_Load(object sender, EventArgs e)
{
TimeSpan timeSpane = new TimeSpan();
string constr = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
using (SqlConnection conn = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("SELECT CONVERT(VARCHAR(10),InTime,108 ), CONVERT(VARCHAR(10),outTime,108 ) FROM UserTime WHERE Id = 1", conn))
{
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DateTime inTime = Convert.ToDateTime(dt.Rows[i][0].ToString(), new CultureInfo("en-Gb"));
DateTime outTime = Convert.ToDateTime(dt.Rows[i][1].ToString(), new CultureInfo("en-Gb"));
timeSpane += outTime.Subtract(inTime);
}
}
}
this.lblTimeDifference.Text = timeSpane.ToString();
}
}
}
SQL
