How to get Hours worked by employee using

Kedar Pawgi

Hi i would like to calculate working hours by employee.

I have 3 text boxes txtMorningInTime,txtMorningOutTime,txtMorningTotHrs

I will enter logged in time , logged out time and then i should get the correct working hours. By viewing some links here i tried but its not working. i am using following code suggested by some one here on C# Corner

DateTime loggedIn = Convert.ToDateTime(txtMorningInTime.Text);

DateTime loggedOut = Convert.ToDateTime(txtMorningOutTime.Text);

TimeSpan totHrs = loggedIn - loggedOut;

txtMorningTotalHrs.Text = totHrs.ToString();

But whats happening is ,if i put loggedin time as 10.30(its AM) and logged out time is 2.30 (PM), it should calculate 4 hours.

when i debug its converting the value in txtMorningInTime.text as (30/10/2020) and giving error string was not in correct format for txtMorningOutTime.Text.

what is the solution for this. I need some urgent help. How can i convert the textbox time to time and calculate total working hours.

Thanks In Advance.

2 Replies

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

Kedar Pawgi6y ago
Hi Salman
Thanks for your quick reply. I followed the link that you provided. What you provided is working fine. But i have some issues, please help me regarding that.

1) Here (10,12) are already defined and 12-10 i calculate properly 2 hrs.
2) Both 10,12 (1st Arguments for TimeSpan ) must be integer, suppose in time is 10.30 and out time is 2 or 2.30 then how to calculate time difference, as it give string not in correct format error.
3) We calculate working hours from InTime - Out Time (here in this case is reverse thats why its giving 2 hrs positive)
4) But when we do 10-12 then it comes -ve , how to sort that out.

thanks in advance.

Following code was in the link which i use....

TimeSpan timeSpan1 = new TimeSpan(10, 0, 0);
TimeSpan timeSpan2 = new TimeSpan(12, 0, 0);
var timeDiff = timeSpan2.Subtract(timeSpan1);

Following is code after modifying above code

TimeSpan inTime = new TimeSpan( Convert.ToInt16(txtMorningInTime.Text), 0, 0);
TimeSpan outTime = new TimeSpan(Convert.ToInt16(txtMorningOutTime.Text), 0, 0);
var timeDiff = inTime.Subtract(outTime);
txtMorningTotalHrs.Text = timeDiff.ToString();

Kindly help me out Thanks in advance.
0
Salman Beg6y ago
Check this link it may help you, https://www.codeproject.com/Questions/334475/Get-the-number-of-hours-between-two-time-in-Csharp
0