he has worked how many hours ?

Question

1.00/5 (1 vote)

See more:

Hello,

I have working on asp.net with c#, In I want to create one small module which related attendance and overtime.
Means, One man enter with that datetime and also leave with that datetime,

like Enter Date: 15/12/2014 21:00
Leave Date: 16/12/2014 11:00

so, I want to know, he has worked how many hours ?, with above datetime.
By manually he has worked around 14 Hours. but i want calculate with C#.

Thanks & Regards.

Posted 14-Dec-14 22:25pm

Pratham4950

Add a Solution

Comments

Thanks7872 15-Dec-14 4:39am

You know there is something called timespan. Then what have you tried your self? Any efforts?

Pratham4950 15-Dec-14 4:57am

Yes, I have use like this.
string enter = "15/12/2014 21:00";
string leave = "16/12/2014 11:00";
TimeSpan dt1 = TimeSpan.Parse(enter.ToString());
TimeSpan dt2 = TimeSpan.Parse(leave.ToString());
TimeSpan tsWorkHours = dt2 - dt1 ;

But, with this "String was not recognized as a valid TimeSpan."
this error is occurred on "TimeSpan dt1 = TimeSpan.Parse(enter.ToString());" this line..

Thanks7872 15-Dec-14 5:14am

Then you were suppose to explain this story while posting question. Never assume that we can read your mind.

Pratham4950 15-Dec-14 5:22am

Right, Now you have any idea for that ?

Richard MacCutchan 15-Dec-14 6:19am

Why are you calling ToString on a string variable?

3 solutions

Solution 1

Use a TimeSpan[^].

Posted 14-Dec-14 22:31pm

Richard MacCutchan

Solution 2

Something like:

C#

string enter = "15/12/2014 21:00";
string leave = "16/12/2014 11:00";
DateTime dtEnter = DateTime.Parse(enter);
DateTime dtLeave = DateTime.Parse(leave);
TimeSpan tsWorkHours = dtLeave - dtEnter;
Console.WriteLine("Work hours {0}", tsWorkHours.Hours);

Posted 14-Dec-14 22:38pm

CPallini

Comments

Pratham4950 15-Dec-14 4:48am

@CPallini Yes, something like this, but when i have trying like this that time
"String was not recognized as a valid DateTime" this error is occurred on this
"DateTime dtEnter = DateTime.Parse(enter);" line..

lukeer 15-Dec-14 6:19am

Use DateTime.TryParseExact()[^] instead of a simple DateTime.Parse()[^]. That way, you can specify the exact (hence the method name) structure of the date that gets entered. That helps to handle cultural differences in writing a date.

TheRealSteveJudge 15-Dec-14 7:13am

You did not ignore the fact that the dates were given as strings. 5*

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)

TheRealSteveJudge · Accepted Answer · 2014-12-14T23:06:00

Solution 3

You must use DateTime.Subtract() method.
Then you must get the TotalHours property of the TimeSpan.

C#

DateTime enterDate = new DateTime(2014, 12, 15, 21, 0, 0);
DateTime leaveDate = new DateTime(2014, 12, 16, 11, 0, 0);

TimeSpan duration = leaveDate.Subtract(enterDate);

double workingHours = duration.TotalHours;

Posted 14-Dec-14 23:06pm

TheRealSteveJudge

Updated 14-Dec-14 23:09pm

v2

Comments

TheRealSteveJudge 15-Dec-14 5:49am

WTF is wrong with this solution? Somebody voted it down. Thank you!

lukeer 15-Dec-14 6:14am

Nothing needs to be wrong in a solution for it to get downvoted. That just happens.

Richard MacCutchan 15-Dec-14 6:21am

Probably because you ignored the fact that OP has specified that his time values are stored as strings. The grammar police are everywhere.

CPallini 15-Dec-14 7:00am

Have my 5 for balancing.

TheRealSteveJudge 15-Dec-14 7:12am

Thank you!

TheRealSteveJudge 15-Dec-14 6:18am

I thought, voting down is used for poor solutions only...

TheRealSteveJudge 15-Dec-14 6:34am

@Pratham Dave: Did I misunderstand your problem?