How to calculate Hours in Time Difference

Question

0.00/5 (No votes)

See more:

Hello Sir,

I want to calculate Hours from Time..

Like: StartTime:-9:30

EndTime:-10:30
TotalTime(Hours):-1

I have to calcuate the difference of Two

my code below:-

C#

public void TotalTime()
      {
          try
          {
              DataTable dt = new DataTable();
                  if (dt.Rows.Count > 0)
                  {
                      GridViewRow row = grdDaily.HeaderRow;
                      TextBox txtStartTime = (TextBox)row.FindControl("txtStartTime");
                      TextBox txtEndTime = (TextBox)row.FindControl("txtEndTime");
                      TextBox txtTotalTime = (TextBox)row.FindControl("txtTotalTime");

                      txtTotalTime.Text = Convert.ToDateTime(dt.Compute(" EndTime - StartTime", "EndTime>-1")).ToString("0.00");
                  }
           
          }
          catch
          {
          }
      }

Posted 20-Dec-11 20:30pm

Prashant Srivastava LKO

Updated 20-Dec-11 20:32pm

uspatel

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2011-12-20T20:36:00

Solution 1

Use the TimeSpan class.

E.g.

TimeSpan span3 = span1.Subtract(span2);
Console.Write("Difference in hours - " + span3.Hours);

You can convert the text box values to DateTime values by using the DateTime.TryParse method.

Posted 20-Dec-11 20:36pm

Abhinav S

Updated 20-Dec-11 20:37pm

v2

Comments

Prashant Srivastava LKO 21-Dec-11 2:53am

Sir, Both fields are inside gridview i.e. my problem please guide for this thing

K Herms · Answer 2 · 2011-12-20T22:04:00

Solution 2

You can also subtract two datetime objects to get a timespan:

DateTime startDate; 
DateTime endDate;
if(DateTime.TryParse(txtStartTime.Text, out startDate) && DateTime.TryParse(txtEndTime.Text, out endDate)){
    TimeSpan duration = endDate - startDate;
    int hours = duration.Hours;
}

Posted 20-Dec-11 22:04pm

K Herms

Comments

Prashant Srivastava LKO 21-Dec-11 5:58am

Both fields are inside gridview i.e. my problem please guide for this thing

Prashant Srivastava LKO 21-Dec-11 5:58am

I am unable to find control inside gridview

K Herms 21-Dec-11 6:42am

When do you call TotalTime()? By the way your question is wrong, it is not about calculating time but getting the textboxes.

Prashant Srivastava LKO 22-Dec-11 0:07am

So Please help me in this way as you told me above

K Herms 22-Dec-11 3:16am

What is your use case, what do you want to achieve? When do you want to have the duration in hours? Do you want to show it in the gridview as a column or do you want to have the duration in hours when you click a button?

Prashant Srivastava LKO 23-Dec-11 13:31pm

hi Kherms
Thanks to share you thoughts well I have solved this question