Attendance Sheet

[abid hussain]

Request assistance in reformatting attendance data for 70 employees. It is currently in horizontal format (21st–20th). Please convert it to vertical format with each row showing one employee’s attendance per date, and include daily OT hours.
Final structure: 1. Emp ID 2. Date 3. Attendance Status 4. OT Hrs.
Your support is appreciated.

 

[vletm]

Check Sheet2

 

[abid hussain]

Want this way date wise, (Final structure column: 1. Emp ID, 2. Date, 3. Attendance Status, 4. OT Hrs.) I attached sample

 

[vletm]

You can add as many employees there as You need.
Usage: press [ Do It ]-button

 

[abid hussain]

I need overtime also

 

[vletm]

I know over 57 different overtimes rules.

 

[abid hussain]

1. Emp ID
2. Date ( DD/MM/YYYY)
3. Attendance Status ( DP, WO, PH, CL, SL, PL, ABS)
4. OT Hrs

 

[vletm]

As written in #6
... I know over 57 different overtimes rules.

 

[abid hussain]

what's this is

 

[abid hussain]

Need to add Overtime hours also

 

[vletm]

You have already needed ... to add Overtime hours ... for weeks.
... I cannot figure any added Overtimes there!
Many rules says that
someone has to do something that there could be overtimes
... and sometimes only rules would give overtimes.
Do You need add fixed Overtimes hours ... hmm?
... or what kind of Overtime hours You need to add ... somewhere?

 

[abid hussain]

what I want
1.Emp ID
2. Date ( DD/MM/YYYY)
3. Attendance Status ( DP, WO, PH, CL, SL, PL, ABS)
4. OT Hrs shall be under each day of attendance status ( myself put hours there)

 

[abid hussain]

Example:
Empl ID - Date - Attendance - OT Hrs
1001 21/5/25 DP 3

 

[vletm]

If I tried to figure Your ... want ... then You could had done it Yourself a long time ago.
You seems to copy and paste same whole phrase instead of answer.
Take care.