How to calculate difference between 2 TimeSpan ?

Abhilash J A

Hello Everyone,

In my MVC4 project, I want to calculate the difference of employee's checkIn and checkOut time. But the 'workedTime' shows munus sign. How can I remove when page showing in browser?

TimeSpan d1 = new TimeSpan(00,00,00);

d1 ="08:14:55";

TimeSpan day = new TimeSpan(08, 30, 00);

TimeSpan workedTime = new TimeSpan(00, 00, 00);

workedTime = d1.Subtract(day);

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajeesh Menoth10y ago
Accepted answer
Hi,

You can use TimeSpan.Duration().

Try this code :
using System;
public class Program
{
public static void Main()
{
TimeSpan d1 = new TimeSpan(08, 15, 00);
TimeSpan day = new TimeSpan(08, 30, 00);
TimeSpan workedTime = new TimeSpan(00, 00, 00);
workedTime = (d1.Subtract(day));
Console.WriteLine(workedTime.Duration());
}
}
Reference :

http://stackoverflow.com/questions/1018643/handle-negative-time-spans

Demo :

https://dotnetfiddle.net/FlZwrf
Nitin Sontakke10y ago
These are called "strategic decisions". In code you may choose do ignore any entry. However, the employee will be fighting tooth and nail about it with HR / Management.
So you will need to involve HR, explain them the situation and request them a strategy to resolve it. It is their call. All you can do it just implement the logic.
HR will need to educate employees about how the system is working. Some sort ofdiscipline will need to enforced for correct functioning of the system.
Abhilash J A10y ago
Hello Nithin Sontakke,
Exactly what you say is my situation. I am getting data like this :-Entry - Exit - Entry - Exit.
But now happening some times like thisEntry - Entry - Exit. I do not have idea how to solve this issue?
Nitin Sontakke10y ago
Looks like you misunderstood my response. I never expected that you write a trigger to do this.
What I mean is you can do this in a stored procedure.
Believe it or not, in past I have worked on this table structure. I believe it is a cosec database for Matrix biometric attendance system.
The only question was what if you get data like
Entry - Entry - Exit or Entry - Exit - Exit
Notice that person either entered twice and existed twice. Either he forgot to punch or tail-gated. We don't know. How to resolve these scenarios. You will need to think and decide on this even if you do it in C#
Hope it helps! My help is available on request.
Abhilash J A10y ago
Hello Everyone,
Thank you for replay me.
I want workedTime output without minus sign. When substract d1- day. Now It will get minus value. I can not substract day-d1, because d1 means employee CheckIn time. It will be increase and decrease sometime with respect to checkIn time.
Abhilash J A10y ago
Hello Nitin Sontakke,

Excuse me Sir, Ofcourse You told me that. This was the question url that me asked.

http://www.c-sharpcorner.com/Forums/how-to-calculate-the-total-hours-worked-by-employee-per-day

Actually I do not know how create triggers for calculate each employe's checkIn and checkOut time. Then I thought, handle with c#.

Thanks for replay me.
Esakki Muthu10y ago
Hi Abhilash,
//checkin time
var t1 = new TimeSpan(08, 14, 55).Ticks;
//check out time
var t2 = new TimeSpan(08,30,00).Ticks;
//worked hours
var worked = new DateTime(t2 - t1).TimeOfDay;
Midhun Tp10y ago
Hi,
What is your expected result here? I think d1 ="08:14:55"; will throw error.
Nitin Sontakke10y ago
If you are referring to same project that you asked question about previously, i strongly suggest that you do all of this on server side itself. It will be easy and quick.
Should you need any help doing it, please do get in touch with me.