calculate hours using date time picker..

Question

0.00/5 (No votes)

See more:

Hi friends,
I m bulding a window application "LEAVE MANAGEMENT SYSTEM",In this i have take two date time picker.i bulid this leave management system for industry where working hours is 8.i want to calculate "working hours of leave using date time picker"..
pls help.
i dnt know how to take diff from two date time picker and i user select 1 day leave than in working hours day should be 8 hours..
Thanks in advance.

Posted 1-Aug-11 18:55pm

advancedansh

Add a Solution

3 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-08-01T19:00:00

Solution 1

To get the difference between two date time values, use the Timespan class.

C#

DateTime dt1 = firstdate;
DateTime dt2 = seconddate;

TimeSpan ts = dt1 - dt2;

int hours = ts.Hours;

Posted 1-Aug-11 19:00pm

Abhinav S

Comments

Sergey Alexandrovich Kryukov 3-Aug-11 5:47am

Correct, my 5. Also, TotalHours can be used to get a fractional number; "-" operator provides better readability.
--SA

RaisKazi · Answer 2 · 2011-08-01T19:02:00

Solution 2

Try as below code.

DateTime startTime = Convert.ToDateTime(DateTimePicker1.value); 
DateTime endTime = Convert.ToDateTime(DateTimePicker2.value); 

TimeSpan span = endTime.Subtract(startTime); 

int hoursDifference = span.Hours;

Posted 1-Aug-11 19:02pm

RaisKazi

Comments

advancedansh 2-Aug-11 2:02am

thanks but would u like to tell me if i do this then user select two diff date in dtp but same time let sy 12 o'clock then what happen it only give same days difference and hours diff = 0;

RaisKazi 2-Aug-11 3:10am

Then try as below.

DateTime startTime = Convert.ToDateTime(DateTimePicker1.value);
DateTime endTime = Convert.ToDateTime(DateTimePicker2.value);

TimeSpan span = endTime.Subtract(startTime);

int daysDiff = span.Days;
int hoursDiff = span.Hours;

hoursDiff = hoursDiff + ( daysDiff * 24);

RaviRanjanKr 2-Aug-11 8:28am

My 5+

RaisKazi 2-Aug-11 8:57am

Thanks Ravi.

Sergey Alexandrovich Kryukov 3-Aug-11 5:49am

My 4. Subtraction operator "-" would provide much better readability than Subtract; TotalHours can be used for fractional number.
--SA

Member 11226623 · Answer 3 · 2014-11-13T07:32:00

DateTime startTime = Convert.ToDateTime(_dtpOutageStart.Value);
DateTime endTime = Convert.ToDateTime(_dtpOutageComplte.Value);

TimeSpan span = endTime.Subtract(startTime);

_txtTotalOutage.Text = span.ToString();

result =day:hour:minitues

actually i wan day=hour+hour:minute

for example 1 day 24 hour and 2hour 25 minutes total 26 hour so I need 26 hour:25 minutes is any body help me.