calculate working hours.

[Nagaraju_KCS]

Hi Community,

PFA,

Emp_Id	Date	In-time	Out-Time	Working Hours
c41059	11/1/2013	9am	6pm
c41060	11/2/2013	9am	5pm
c41061	11/3/2013	9am	4:45pm
c41062	11/4/2013	9am	7pm
c41063	11/5/2013	9am	8pm
c41064	11/6/2013	9am	1pm
c41065	11/7/2013	9am	4pm
c41066	11/8/2013	9am	2:45pm
c41067	11/9/2013	9am	6pm
c41068	11/10/2013	9am	6pm
c41069	11/11/2013	9am	7pm
c41070	11/12/2013	9am	8pm
c41071	11/13/2013	9am	12:30pm

How to calculate working hours and sundays..

[Nagaraju_KCS]

anyone can help me..

[fred_s]

I do prefer 24-hour time format 🙂

The script is a disaster but does it's job