Syed Ather

Syed Ather

  • NA
  • 132
  • 12.6k

how to calculate working hours of employee in asp.net

Jul 29 2017 3:33 AM
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

AttendaneIdEmpIDCdateTimeLogStatus
11D17/29/2017 09:07:00 
12D17/29/2017 13:00:00 
13D17/29/2017 14:05:00 
14D17/29/2017 17:41:00
 
thank you 

Answers (6)