how to calculate working hours of employee in asp.net

Question

i have below table in and i wan to calculate employee daily working hours

i want to calculate employees in time and out time check box shows login status that when employee login and how many time he logedout
so please help me i m confuse how to calculate time. i m able to sum the in time and out time buts not giving me correct result

AttendaneId	EmpID	Cdate	Time
11	D1	7/29/2017	09:07:00
12	D1	7/29/2017	13:00:00
13	D1	7/29/2017	14:05:00
14	D1	7/29/2017	17:41:00

thank you

Amit Gupta · Answer

Hey Why using sum? Here's the logic 1. Get the minimum time as IN TIME and maximum time as OUT TIME 2. If its done then subtract that to get the hours var inTime = Convert.ToDateTime( "InTime" ); var outTime = Convert.ToDateTime( "OutTime" ); var totalHrs = (outTime-InTime).TotalHours;

Susanta Rout · Answer

https://stackoverflow.com/questions/35907459/how-to-get-the-total-working-hours-for-employees-with-sql-server

Susanta Rout · Answer

https://www.codeproject.com/Questions/469157/Calculate-total-working-hours-with-min-using-sql

Susanta Rout · Answer

u can follow this https://www.aspsnippets.com/Articles/Simple-Cursor-Tutorial-with-Syntax-example-in-SQL-Server.aspx

Rajeesh Menoth · Answer

Hi, I think you can use the linq query. Try this : var inTime = "10:00" ; var outTime = DateTime.Now.TimeOfDay; var totalHours = Convert.ToDateTime(inTime).TimeOfDay.Subtract(outTime); Console.WriteLine(totalHours); //Total Hours Reference : https://dotnetfiddle.net/K42LSY https://forums.asp.net/t/1824806.aspx?LINQ+calculate+working+hours+duration

Puneet Kankar · Answer

pls check this link https://www.sqlservercentral.com/Forums/Topic1554257-145-1.aspx

how to calculate working hours of employee in asp.net

Answers (6)