How to calculate hours between two time pickers

Question

3.67/5 (2 votes)

See more:

Dear Frnds,

I need. how to calculate hours between two time pickers... can anyone help me..

Thanks & Regards,
Vivek .R

Posted 29-Apr-14 22:53pm

Vivek.anand34

Add a Solution

Comments

Tejas Vaishnav 30-Apr-14 4:59am

Convert your time picker value to time stamp and subtract it, it will return time stamp and you can get hours, minuet, seconds etc from subtraction result.

Emre Ataseven 30-Apr-14 5:33am

http://bit.ly/1ksjMhn

4 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)

phil.o · Answer 1 · 2014-04-29T22:57:00

Solution 1

You can subtract a DateTime value from another to get a TimeSpan value. This way:

C#

DateTime d1 = dtPicker1.Value;
DateTime d2 = dtPicker2.Value;
TimeSpan ts = d1 - d2;
double result = ts.TotalHours;

Posted 29-Apr-14 22:57pm

phil.o

Comments

Kornfeld Eliyahu Peter 30-Apr-14 4:59am

Very nice! I was sure that we need to use Google for that :-)...

phil.o 30-Apr-14 5:02am

:)

Volynsky Alex 30-Apr-14 5:04am

Yes, nice!

Sanket Saxena 30-Apr-14 5:21am

Quite simple and working code :)

DamithSL 30-Apr-14 5:54am

what is the date time picker giving direct DateTime as value?

phil.o 30-Apr-14 5:56am

Sorry, I don't understand your question.

DamithSL 30-Apr-14 5:59am

is there any datetime picker control which giving value property as C# DateTime object? in your code you have using dtPicker1.Value assigned directly to a DateTime

phil.o 30-Apr-14 6:01am

At least, MSDN tells this so:<br>
DateTimePicker Class

DamithSL 30-Apr-14 6:05am

:( that is System.Windows.Forms haven't you see the TAG of the question, it is ASP.NET

phil.o 30-Apr-14 6:09am

Maybe but anyway, the described issue is not the use of DateTimePickers, but the computation on their values.

DamithSL · Answer 2 · 2014-04-29T23:09:00

it depend on the date time picker you are currently using, check below steps for jquery date time picker

1.Download date time picker from http://xdsoft.net/jqplugins/datetimepicker/
2.Add jquery.datetimepicker.js, jquery.js and jquery.datetimepicker.css files to asp.net solution and add links

ASP.NET

<head  runat="server">
    <title></title>
    <link rel="stylesheet" type="text/css" href="./jquery.datetimepicker.css" />
    <script type="text/javascript" src="./jquery.js"></script>
    <script type="text/javascript" src="./jquery.datetimepicker.js"></script>
</head>

3. Add two text box for the two date time pickers

ASP.NET

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />

4. Need to add javascript to populate the date time picker

JavaScript

<script type="text/javascript">
    $(document).ready(function () {
        $('#TextBox1').datetimepicker();
        $('#TextBox1').datetimepicker({ value: '2015/04/15 05:03', step: 10 });
        $('#TextBox2').datetimepicker();
        $('#TextBox2').datetimepicker({ value: '2015/04/15 05:03', step: 10 });
    });
</script>

5. you can set default date time from server side(page load) like below

C#

TextBox1.Text = DateTime.Now.ToString("yyyy/MM/dd HH:mm");
TextBox2.Text = DateTime.Now.ToString("yyyy/MM/dd HH:mm");

6. date time value can be converted to DateTime as below (on button click)

C#

DateTime datetime1;
DateTime datetime2;
if (DateTime.TryParseExact(TextBox1.Text, "yyyy/MM/dd HH:mm", CultureInfo.InvariantCulture, DateTimeStyles.None, out datetime1) && DateTime.TryParseExact(TextBox2.Text, "yyyy/MM/dd HH:mm", CultureInfo.InvariantCulture, DateTimeStyles.None, out datetime2))
{
    var hours = datetime2.Subtract(datetime1).TotalHours;
}

Sample project can be downloaded from below link
DateTimePicker Sample VS2008 Web Application.zip[^]

RahulMGunjal · Answer 3 · 2014-04-30T23:10:00

check following code block from http://msdn.microsoft.com/en-us/library/aa287590(v=vs.71).aspx[^]

DateTime oldDate = new DateTime(2002,7,15);
DateTime newDate = DateTime.Now;

// Difference in days, hours, and minutes.
TimeSpan ts = newDate - oldDate;
// Difference in days.
int differenceInDays = ts.Days;

Console.WriteLine("Difference in days: {0} ", differenceInDays);

Kan07 · Answer 4 · 2014-04-30T00:52:00

Solution 3

DateTime startTime = convert.todatetime(dtp.text);

DateTime endTime = convert.todatetime(dtp2.text);

TimeSpan span = endTime.Subtract ( startTime );

Console.WriteLine( "Time Difference (hours): " + span.Hours );

Posted 30-Apr-14 0:52am

Kan07