Spreadsheet: 138718d1327854511-clear-value-excel-forum-ikhtiar
Sheet: CAL BLN 1

 |  |  |  |  |  |  | SUNDAY |  |  | MONDAY |  |  | TUESDAY |  |  | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY |  |  | SATURDAY
 | Working Days |  |  | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-01 00:00:00
 | Working Hour/Day |  |  | 8.5 |  |  | 2012-01-01 00:00:00 |  |  | 2012-01-02 00:00:00 |  |  | 2012-01-03 00:00:00 |  |  | 2012-01-04 00:00:00 |  |  | 2012-01-05 00:00:00 |  |  | 2012-01-06 00:00:00 |  |  | 2012-01-07 00:00:00 |  |  |  |  |  |  |  |  | 2012-01-01 00:00:00
 | Normal working hours |  |  | 161.5 |  |  |  |  |  | 17:45:00 | ~ | 18:45:00 | 17:45:00 | ~ | 20:15:00 | 17:45:00 | ~ | 23:45:00 | 17:45:00 | ~ | 21:45:00 | 17:45:00 | ~ | 22:45:00 | 10:00:00 | ~ | 20:30:00
 | Standard working hours |  |  | 185.5 |  |  |  |  |  | 0.9999999999999991 |  |  | 2.499999999999999 |  |  | 6 |  |  | 3.999999999999999 |  |  | 4.999999999999998 |  |  | 10.5 |  |  |  |  |  |  |  | ~
 | Service OverTime |  |  | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:30:00 | ~ | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PROTON |  |  |  |  |  |  |  |  |  |  |  | Month | Working Day | 17:45:00 | 17:10:00 | PERODUA
 |  |  |  |  |  |  | 2012-01-08 00:00:00 |  |  | 2012-01-09 00:00:00 |  |  | 2012-01-10 00:00:00 |  |  | 2012-01-11 00:00:00 |  |  | 2012-01-12 00:00:00 |  |  | 2012-01-13 00:00:00 |  |  | 2012-01-14 00:00:00 |  |  |  |  |  | 1 | 19 | 18:45:00 | 18:10:00 | TOYOTA
 |  |  |  |  |  |  |  |  |  |  |  |  | 17:45:00 | ~ | 20:45:00 |  |  |  | 17:45:00 | ~ | 23:15:00 | 17:45:00 | ~ | 20:45:00 |  |  |  |  |  |  | 2 | 21 | 19:15:00 | 18:40:00 | PROTON
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  | 5.499999999999999 |  |  | 3 |  |  |  |  |  |  |  |  | 3 | 22 | 19:45:00 | 19:10:00 | ARRK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 | ~ | 17:30:00 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 21 | 20:15:00 | 19:40:00 | TCMA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ARRK / PROTON |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 22 | 20:45:00 | 20:10:00 | ARRK / PROTON
 | YEAR |  |  | MONTH |  |  | 2012-01-15 00:00:00 |  |  | 2012-01-16 00:00:00 |  |  | 2012-01-17 00:00:00 |  |  | 2012-01-18 00:00:00 |  |  | 2012-01-19 00:00:00 |  |  | 2012-01-20 00:00:00 |  |  | 2012-01-21 00:00:00 |  |  |  |  |  | 6 | 21 | 21:15:00 | 20:40:00 | PROTON / PERODUA
 | 2012 |  |  | 1 |  |  |  |  |  | 17:45:00 | ~ | 20:15:00 | 17:45:00 | ~ | 20:15:00 | 17:45:00 | ~ | 21:45:00 | 17:45:00 | ~ | 22:45:00 | 17:45:00 | ~ | 19:45:00 |  |  |  |  |  |  | 7 | 22 | 21:45:00 | 21:10:00 | AL
 |  |  |  |  |  |  |  |  |  | 2.499999999999999 |  |  | 2.499999999999999 |  |  | 3.999999999999999 |  |  | 4.999999999999998 |  |  | 1.999999999999998 |  |  |  |  |  |  |  |  | 8 | 17 | 22:15:00 | 21:40:00 | 1/2 AL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 20 | 22:45:00 | 22:10:00 | MC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 21 | 23:15:00 | 22:40:00
 |  |  |  |  |  |  | 2012-01-22 00:00:00 |  |  | 2012-01-23 00:00:00 |  |  | 2012-01-24 00:00:00 |  |  | 2012-01-25 00:00:00 |  |  | 2012-01-26 00:00:00 |  |  | 2012-01-27 00:00:00 |  |  | 2012-01-28 00:00:00 |  |  |  |  |  | 11 | 19 | 23:45:00 | 23:10:00
 | 2012-01-01 00:00:00 |  | ~ | 2012-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:45:00 | ~ | 22:45:00 | 17:45:00 | ~ | 21:15:00 | 09:00:00 | ~ | 12:30:00 |  |  |  | 12 | 20 |  | 23:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.999999999999998 |  |  | 3.499999999999998 |  |  | 3.500000000000001
 | TOTAL HOUR |  | = | 68.49999999999999
 |  |  |  |  |  |  | 2012-01-29 00:00:00 |  |  | 2012-01-30 00:00:00 |  |  | 2012-01-31 00:00:00 |  |  | 2012-02-01 00:00:00 |  |  | 2012-02-02 00:00:00 |  |  | 2012-02-03 00:00:00 |  |  | 2012-02-04 00:00:00
 | COUNTED OT |  | = | 44.49999999999999
 | RPL |  | = | 5.562499999999998
 |  |  |  |  |  |  | 2012-02-05 00:00:00 |  |  | 2012-02-06 00:00:00 |  |  | 2012-02-07 00:00:00 |  |  | 2012-02-08 00:00:00 |  |  | 2012-02-09 00:00:00 |  |  | 2012-02-10 00:00:00 |  |  | 2012-02-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUBLIC HOLIDAY |  |  |  |  | SUNDAY & REPLACEMNET |  |  |  | COMPANY HOLIDAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-01 00:00:00 |  |  |  |  | 2012-01-25 00:00:00 |  |  |  | 2012-11-12 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-14 00:00:00 |  |  |  |  | 2012-08-21 00:00:00 |  |  |  | 2010-09-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-23 00:00:00 |  |  |  |  | 2012-08-22 00:00:00 |  |  |  | 2010-09-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-24 00:00:00 |  |  |  |  | 2012-08-23 00:00:00 |  |  |  | 2010-09-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-05 00:00:00 |  |  |  |  | 2012-08-24 00:00:00 |  |  |  | 2010-09-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-01 00:00:00 |  |  |  |  | 2012-10-25 00:00:00 |  |  |  | 2010-11-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-05 00:00:00 |  |  |  |  | 2012-11-14 00:00:00 |  |  |  | 2010-11-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-02 00:00:00 |  |  |  |  | 2011-05-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-17 00:00:00 |  |  |  |  | 2011-08-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-19 00:00:00 |  |  |  |  | 2011-09-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-20 00:00:00 |  |  |  |  | 2011-10-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-31 00:00:00 |  |  |  |  | 2011-10-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-16 00:00:00 |  |  |  |  | 2011-10-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-26 00:00:00 |  |  |  |  | 2011-11-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-13 00:00:00 |  |  |  |  | 2011-12-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-25 00:00:00 |  |  |  |  | 2010-02-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-01 00:00:00 |  |  |  |  | 2010-11-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-14 00:00:00 |  |  |  |  | 2010-11-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-02-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-02-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-06-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-08-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-09-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-09-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-09-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-11-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-11-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-12-25 00:00:00