C# Time difference calculation

Question

0.00/5 (No votes)

See more:

Hi All,

I have to write a function for calculating the time difference between two tasks entered by the same user which is to be displayed in the excel sheet.How to write that function?

please help me.

Thanks in Advance.

Posted 19-Jul-11 20:00pm

AC777

Updated 8-Jul-18 22:06pm

Ramalinga Koushik

v2

Add a Solution

4 solutions

Solution 3

One improvement: in the solution by Abhinav, it's much better to write the last line like this:

C#

TimeSpan ts = dt1 - dt2;
//yes, subtraction operator "-" is defined, of course

—SA

Posted 20-Jul-11 21:43pm

Sergey Alexandrovich Kryukov

Comments

Dalek Dave 21-Jul-11 3:52am

Explain why better?
Serious question, functionally they are identical.

Sergey Alexandrovich Kryukov 21-Jul-11 4:03am

Functionality? How about maintainability? Apparently, more readable, less confusion what is subtracted from what, no need to remember method name... Operators does not have to be defined from the pure functional stand point, but they are defined -- for good reasons.
Did I explained enough?
--SA

Abhinav S 21-Jul-11 4:01am

Curiosity - How will it be better?

Sergey Alexandrovich Kryukov 21-Jul-11 4:04am

I though it's apparent. I explained above.
--SA

Nagy Vilmos 21-Jul-11 4:34am

If it's an 'improvement' why didn't you just improve the answer instead of creating another answer?

Sergey Alexandrovich Kryukov 21-Jul-11 10:22am

Why not? We always do so. Improvement is quite apparent; I don't see what problem do you see. Just decided to down-vote on this base? Hm...

--SA

Nagy Vilmos 21-Jul-11 10:27am

0. I didn't vote.
1. Your solution is better /from your point of view/, but that does not mean it is better for every one.

Jibesh 18-Dec-12 2:00am

I agree with you Nagy on this matter.

Sergey Alexandrovich Kryukov 18-Dec-12 4:18am

You guys never gave me rational arguments. I explained why it's better, and you did not provide any arguments against my claim. "Same functionality" is true but not an argument. And "1." seems ridiculous to me. Of course, if I have a strong opinion, I try to share it. To say it's not better, you need to explain just one one example when it is not better and why.

Thank you.
—SA

Jibesh 18-Dec-12 4:28am

Sergey this solution never deserve '1' , but this solution is same the other solution by all means. so what other members feel is its good to add to amend this result to other solution. I believe the primary objective of this site is to encourage each other to build a better programming community, develop good programmer etc etc and not merely for points. I do value each members contribution to this site with due respect.

Sergey Alexandrovich Kryukov 18-Dec-12 4:33am

I'm not arguing about the form of the post and even about the votes, not even close. I'm talking only about the coding style and related matters. Why would you care that I post a separate solution, really? Give me the rational arguments against my view of the usage of the operator. If you don't have objections, let's close it.
—SA

Solution 4

Without using any SqlFunction

C#

var grandTotalWork = (from t in db.AssignmentHandymandetails join ad in db.AssignmentDetails on t.assignment_detail_id equals ad.assignment_detail_id where ad.assignment_id == Convert.ToInt32(Label_assignmentId.Text) select new { startTime = t.started_time.Value.TimeOfDay, endTime = t.end_time.Value.TimeOfDay, TotalWorkTime = (t.started_time.Value.TimeOfDay.Duration() - t.end_time.Value.TimeOfDay.Duration()).Duration()});

then you can bind the result in GridView you wish

Posted 17-Dec-12 19:39pm

lamadipen

Updated 17-Dec-12 21:54pm

v2

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)

SanjeevSingh · Accepted Answer · 2011-07-19T20:04:00

Solution 1

hello,

try to use use TimeSpan or search TimeSpan example.

thanks
sanjeev

Posted 19-Jul-11 20:04pm

SanjeevSingh

Comments

walterhevedeich 20-Jul-11 2:14am

Good advice. 5ed.

[no name] 20-Jul-11 2:42am

thanks

Dalek Dave 21-Jul-11 3:51am

Good Call!

Abhinav S · Accepted Answer · 2011-07-19T20:10:00

Solution 2

Try

DateTime dt1 = DateTime.ParseExact(time1, "HH:mm:ss", new DateTimeFormatInfo());
DateTime dt2 = DateTime.ParseExact(time2, "HH:mm:ss", new DateTimeFormatInfo());
TimeSpan ts = dt1.Subtract(dt2);

Posted 19-Jul-11 20:10pm

Abhinav S

Comments

walterhevedeich 20-Jul-11 2:15am

Right. 5ed.

alavee1 18-Aug-13 23:38pm

Simple and clear solution.
Thanks Abhinav S.

Abhinav S 20-Jul-11 2:16am

Thank you.

Sergey Alexandrovich Kryukov 21-Jul-11 3:44am

Correct, my 5, but there is an improvement, please see my solution. Isn't it a bit more clear?
--SA

Abhinav S 21-Jul-11 3:56am

Thanks for the 5 SA.