Spreadsheet: 216149d1361621981-conditional-formating-attendance-sheet-workdurationreport-as-of-20-feb
Sheet: Sheet2

 | Monthly Status Report (Detailed Work Duration)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan 21 2013  To |  |  |  |  | Feb 20 2013
Company: |  |  |  | Default |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Printed On : Feb 21 2013 12:33
Days |  | 21 M | 22 T |  | 23 W | 24 Th | 25 F | 26 St | 27 S | 28 M |  | 29 T | 30 W | 31 Th | 1 F |  | 2 St | 3 S | 4 M | 5 T |  | 6 W | [NAME] | 8 F |  | 9 St | 10 S | 11 M | 12 T | 13 W | 14 Th |  | 15 F | 16 St | 17 S | 18 M | 19 T | 20 W
Department: |  |  | ADMIN
Employee: |  |  | 521 : RAJ SHEKHAR DAS |  |  |  |  | Total Duration: 190:28 Hrs. Total OT: 00:00 Hrs. Present: 21 Absent: 3 WeeklyOff: 8 Holidays: 1 Leaves Taken: 0 Late By Hrs: 4:07 Late By Days: 1 Early By Hrs: 00:23 Early going By Days: 1
Status |  | P | P |  | A | A | A | WO | WO | P |  | P | P | P | P |  | WOP | WO | P | P |  | P | P | P |  | WOP | WO | P | P | P | P |  | H | WO | WO | P | P | P
InTime |  | 08:47 | 08:47 |  |  |  |  |  |  | 08:32 |  | 08:21 | 08:28 | 08:35 | 08:24 |  | 10:40 |  | 08:38 | 08:13 |  | 08:29 | 08:20 | 08:15 |  | 10:52 |  | 08:26 | 08:19 | 08:17 | 08:36 |  |  |  |  | 07:43 | 08:27 | 13:07
OutTime |  | 18:51 | 19:03 |  |  |  |  |  |  | 18:34 |  | 18:38 | 19:41 | 18:34 | 18:57 |  | 15:36 |  | 19:07 | 18:47 |  | 18:59 | 18:51 | 18:40 |  | 15:00 |  | 18:36 | 18:44 | 18:55 | 18:43 |  |  |  |  | 18:59 |  | 17:36
Duration |  | 9:52 | 10:04 |  | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 9:35 |  | 9:39 | 10:42 | 9:35 | 9:58 |  | 4:56 | 00:00 | 10:08 | 9:48 |  | 10:00 | 9:52 | 9:41 |  | 4:08 | 00:00 | 9:37 | 9:43 | 9:56 | 9:44 |  | 00:00 | 00:00 | 00:00 | 10:00 | 9:01 | 4:29
Late By |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4:07
Early By |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:23
OT
Shift |  | FS | FS |  | FS | FS | FS | FS | FS | FS |  | FS | FS | FS | FS |  | FS | FS | FS | FS |  | FS | FS | FS |  | FS | FS | FS | FS | FS | FS |  | FS | FS | FS | FS | FS | FS
Department: |  |  | AE
Employee: |  |  | 520 : SK SAFIKUL HAQUE |  |  |  |  | Total Duration: 55:29 Hrs. Total OT: 00:00 Hrs. Present: 6 Absent: 20 WeeklyOff: 4 Holidays: 1 Leaves Taken: 0 Late By Hrs: 00:00 Late By Days: 0 Early By Hrs: 00:00 Early going By Days: 0
Status |  | A | A |  | A | A | A | A | A | A |  | A | A | A | A |  | A | A | A | A |  | A | A | A |  | WO | WO | P | P | P | P |  | H | WO | WO | P | P | A
InTime |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:01 | 08:53 | 09:05 | 09:00 |  |  |  |  | 09:15 | 09:01
OutTime |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:25 | 18:08 | 18:17 | 18:15 |  |  |  |  | 18:21 | 18:24
Duration |  | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 9:24 | 9:09 | 9:12 | 9:15 |  | 00:00 | 00:00 | 00:00 | 9:06 | 9:23 | 00:00
Late By
Early By
OT
Shift |  | FS | FS |  | FS | FS | FS | FS | FS | FS |  | FS | FS | FS | FS |  | FS | FS | FS | FS |  | FS | FS | FS |  | FS | FS | FS | FS | FS | FS |  | FS | FS | FS | FS | FS | FS
Department: |  |  | Default
Employee: |  |  | T1 : Test Employee 1 |  |  |  |  | Total Duration: 00:00 Hrs. Total OT: 00:00 Hrs. Present: 0 Absent: 31 WeeklyOff: 0 Holidays: 0 Leaves Taken: 0 Late By Hrs: 00:00 Late By Days: 0 Early By Hrs: 00:00 Early going By Days: 0
Status |  | A | A |  | A | A | A | A | A | A |  | A | A | A | A |  | A | A | A | A |  | A | A | A |  | A | A | A | A | A | A |  | A | A | A | A | A | A
InTime
OutTime
Duration |  | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00
Late By
Early By
OT
Shift |  | FS | FS |  | FS | FS | FS | FS | FS | FS |  | FS | FS | FS | FS |  | FS | FS | FS | FS |  | FS | FS | FS |  | FS | FS | FS | FS | FS | FS |  | FS | FS | FS | FS | FS | FS
Employee: |  |  | T2 : Test Employee 2 |  |  |  |  | Total Duration: 00:00 Hrs. Total OT: 00:00 Hrs. Present: 0 Absent: 31 WeeklyOff: 0 Holidays: 0 Leaves Taken: 0 Late By Hrs: 00:00 Late By Days: 0 Early By Hrs: 00:00 Early going By Days: 0
Status |  | A | A |  | A | A | A | A | A | A |  | A | A | A | A |  | A | A | A | A |  | A | A | A |  | A | A | A | A | A | A |  | A | A | A | A | A | A
InTime
OutTime
Duration |  | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00
Late By
Early By
OT
Shift |  | FS | FS |  | FS | FS | FS | FS | FS | FS |  | FS | FS | FS | FS |  | FS | FS | FS | FS |  | FS | FS | FS |  | FS | FS | FS | FS | FS | FS |  | FS | FS | FS | FS | FS | FS
Employee: |  |  | T3 : Test Employee 3 |  |  |  |  | Total Duration: 00:00 Hrs. Total OT: 00:00 Hrs. Present: 0 Absent: 31 WeeklyOff: 0 Holidays: 0 Leaves Taken: 0 Late By Hrs: 00:00 Late By Days: 0 Early By Hrs: 00:00 Early going By Days: 0
Status |  | A | A |  | A | A | A | A | A | A |  | A | A | A | A |  | A | A | A | A |  | A | A | A |  | A | A | A | A | A | A |  | A | A | A | A | A | A
InTime
OutTime
Duration |  | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 |  | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00
Late By
Early By
OT
Shift |  | FS | FS |  | FS | FS | FS | FS | FS | FS |  | FS | FS | FS | FS |  | FS | FS | FS | FS |  | FS | FS | FS |  | FS | FS | FS | FS | FS | FS |  | FS | FS | FS | FS | FS | FS
Department: |  |  | OE
Employee: |  |  | 519 : DEEPAK KUMAR SHAW |  |  |  |  | Total Duration: 205:15 Hrs. Total OT: 00:00 Hrs. Present: 24 Absent: 0 WeeklyOff: 8 Holidays: 1 Leaves Taken: 0 Late By Hrs: 17:37 Late By Days: 19 Early By Hrs: 00:49 Early going By Days: 2
Status |  | P | P |  | P | P | P | WO | WO | P |  | P | P | P | P |  | WOP | WO | P | P |  | P | P | P |  | WO | WO | P | P | P | P |  | H | WOP | WO | P | P | P
InTime |  | 09:52 | 10:30 |  | 08:41 | 08:28 | 08:49 |  |  | 09:26 |  | 09:33 | 09:30 | 09:36 | 09:27 |  | 10:45 |  | 09:23 | 09:36 |  | 09:28 | 09:32 | 09:34 |  |  |  | 09:31 | 10:19 | 09:43 | 09:49 |  |  | 11:55 |  | 10:07 | 11:36 | 12:05
OutTime |  | 18:51 | 19:15 |  | 18:45 | 17:33 | 18:35 |  |  | 18:31 |  | 18:36 | 18:32 | 18:41 | 18:49 |  |  |  | 19:15 | 19:09 |  |  | 18:49 |  |  |  |  | 18:16 | 18:42 | 18:57 | 17:44 |  |  | 16:53 |  | 19:04 | 18:56 | 17:36
Duration |  | 8:59 | 8:45 |  | 9:46 | 8:34 | 9:36 | 00:00 | 00:00 | 9:05 |  | 9:03 | 9:02 | 9:05 | 9:22 |  | 7:15 | 00:00 | 9:52 | 9:33 |  | 8:32 | 9:17 | 8:26 |  | 00:00 | 00:00 | 8:45 | 8:23 | 9:14 | 7:55 |  | 00:00 | 4:58 | 00:00 | 8:57 | 7:20 | 5:31
Late By |  | 00:52 | 1:30 |  |  |  |  |  |  | 00:26 |  | 00:33 | 00:30 | 00:36 | 00:27 |  |  |  | 00:23 | 00:36 |  | 00:28 | 00:32 | 00:34 |  |  |  | 00:31 | 1:19 | 00:43 | 00:49 |  |  |  |  | 1:07 | 2:36 | 3:05
Early By |  |  |  |  |  | 00:26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:23
OT
Shift |  | FS | FS |  | FS | FS | FS | FS | FS | FS |  | FS | FS | FS | FS |  | FS | FS | FS | FS |  | FS | FS | FS |  | FS | FS | FS | FS | FS | FS |  | FS | FS | FS | FS | FS | FS