Spreadsheet: 83842d1283876369-want-to-calculate-8-hours-as-one-working-day-sj
Sheet: 17 March - 19 July 2010

 |  |  | OFF SET BALANCE SHEET
 | Effective |  | March 17 - July 19 , 2010
 |  |  |  |  |  |  |  |  |  |  |  |  | Normalised
 | Sr. No. | Names | Previous Balance | Public HoliDays | Cancelled Off | Extra Hours | Under Time | Off Sets | Total Balance |  |  |  | Previous Balance | Public HoliDay | Cancelled | Extra Hours | Under Time | Offsets | 1 | 1 | 1 | 1 | -1 | -1 | Total
 | 1 | Usman | 28 Days and 4 Hrs | 1 Day |  | 4 Hrs |  |  | 30 Day(s) and 0 Hour(s) |  |  |  | 0000028 Days and     4 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 000004 Hrs 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 28.5 | 1 | 0 | 0.5 | 0 | 0 | 30
 | 2 | [NAME] | 20 Days and 2 Hrs | 1 Day |  | 1 Hr | 5 Hrs | 1 Day | 19 Day(s) and 6 Hour(s) |  |  |  | 0000020 Days and     2 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 000001 Hr 00 Days 00.00 Hrs | 000005 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 20.25 | 1 | 0 | 0.125 | -0.625 | -1 | 19.75
 | 3 | Rose | 4 Days and 5.5 Hrs | 1 Day |  | 6.5 Hrs | 21.5 Hrs |  | 3 Day(s) and 6.5 Hour(s) |  |  |  | 000004 Days and     5.5 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 000006.5 Hrs 00 Days 00.00 Hrs | [NAME] 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 4.6875 | 1 | 0 | 0.8125 | -2.6875 | 0 | 3.8125
 | 4 | Atique | 24 Days and 3 Hrs | 1 Day |  | 5 Hrs | 2.5 Hrs | 1 Day | 24 Day(s) and 5.5 Hour(s) |  |  |  | 0000024 Days and     3 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 000005 Hrs 00 Days 00.00 Hrs | 000002.5 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 24.375 | 1 | 0 | 0.625 | -0.3125 | -1 | 24.6875
 | 5 | Shardul | 26 Days and 7 Hrs | 1 Day | 1 Day | 1 Hr | 7.5 Hrs | 1 Day | 27 Day(s) and 0.5 Hour(s) |  |  |  | 0000026 Days and     7 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 000001 Hr 00 Days 00.00 Hrs | 000007.5 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 26.875 | 1 | 1 | 0.125 | -0.9375 | -1 | 27.0625
 | 6 | Jed | 23 Days and 0.5 Hr | 1 Day |  | 1 Hr | 9 Hrs |  | 23 Day(s) and 0.5 Hour(s) |  |  |  | 0000023 Days and     0.5 Hr 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 000001 Hr 00 Days 00.00 Hrs | 000009 Hrs 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 23.0625 | 1 | 0 | 0.125 | -1.125 | 0 | 23.0625
 | 7 | [NAME] | 9 Days and 6.5 Hrs | 1 Day |  |  | 23.5 Hrs |  | 7 Day(s) and 7 Hour(s) |  |  |  | 000009 Days and     6.5 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 0000023.5 Hrs 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 9.8125 | 1 | 0 | 0 | -2.9375 | 0 | 7.875
 | 8 | Venus | 11 Days and 7.5 Hrs | 1 Day |  |  | 21 Hrs |  | 10 Day(s) and 2.5 Hour(s) |  |  |  | 0000011 Days and     7.5 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 0000021 Hrs 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 11.9375 | 1 | 0 | 0 | -2.625 | 0 | 10.3125
 | 9 | UDay | 8 Days and 5 Hrs | 1 Day |  |  | 10 Hrs | 1 Day | 7 Day(s) and 3 Hour(s) |  |  |  | 000008 Days and     5 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | [NAME] 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 8.625 | 1 | 0 | 0 | -1.25 | -1 | 7.375
 | 10 | [NAME] | 8 Days and 7 Hrs | 1 Day |  | 1 Hr | 11 Hrs |  | 8 Day(s) and 5 Hour(s) |  |  |  | 000008 Days and     7 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 000001 Hr 00 Days 00.00 Hrs | 0000011 Hrs 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 8.875 | 1 | 0 | 0.125 | -1.375 | 0 | 8.625
 | 11 | [NAME] | 15 Days and 7 Hrs | 1 Day |  |  | 4 Hrs |  | 16 Day(s) and 3 Hour(s) |  |  |  | 0000015 Days and     7 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 000004 Hrs 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 15.875 | 1 | 0 | 0 | -0.5 | 0 | 16.375
 | 12 | Sattar | 3 Days and 2 Hrs | 1 Day |  |  | 18 Hrs | 2 Days | 0 Day(s) and 0 Hour(s) |  |  |  | 000003 Days and     2 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 0000018 Hrs 00 Days 00.00 Hrs | 000002 Days 00 Days 00.00 Hrs | 3.25 | 1 | 0 | 0 | -2.25 | -2 | 0
 | 13 | Ricky | 16 Days and 7 Hrs | 1 Day |  | 1 hr | 14 Hrs |  | 16 Day(s) and 2 Hour(s) |  |  |  | 0000016 Days and     7 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 000001 hr 00 Days 00.00 Hrs | 0000014 Hrs 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 16.875 | 1 | 0 | 0.125 | -1.75 | 0 | 16.25
 | 14 | [NAME] | 11 Days and 3 Hrs | 1 Day |  | 1 Hr | 11 Hrs |  | 11 Day(s) and 1 Hour(s) |  |  |  | 0000011 Days and     3 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 000001 Hr 00 Days 00.00 Hrs | 0000011 Hrs 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 11.375 | 1 | 0 | 0.125 | -1.375 | 0 | 11.125
 | 15 | Sixto | 11 Days and 4 Hrs | 1 Day |  | 2 Hrs | 11 Hrs |  | 11 Day(s) and 3 Hour(s) |  |  |  | 0000011 Days and     4 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 000002 Hrs 00 Days 00.00 Hrs | 0000011 Hrs 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 11.5 | 1 | 0 | 0.25 | -1.375 | 0 | 11.375
 | 16 | Baptist | 22 Days and 4.5 Hrs | 1 Day |  | 3 Hrs | 15 Hrs | 1 Day | 21 Day(s) and 0.5 Hour(s) |  |  |  | 0000022 Days and     4.5 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 000003 Hrs 00 Days 00.00 Hrs | 0000015 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 22.5625 | 1 | 0 | 0.375 | -1.875 | -1 | 21.0625
 | 17 | Beverly | 21 Days and 4.5 Hrs | 1 Day |  | 1 hr | 5 Hrs |  | 22 Day(s) and 0.5 Hour(s) |  |  |  | 0000021 Days and     4.5 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 000001 hr 00 Days 00.00 Hrs | 000005 Hrs 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 21.5625 | 1 | 0 | 0.125 | -0.625 | 0 | 22.0625
 | 18 | Pramod | 28 Days and 1.5 Hrs | 1 Day |  | 3 Hrs | 4.5 Hrs | 1 Day | 28 Day(s) and 0 Hour(s) |  |  |  | 0000028 Days and     1.5 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 000003 Hrs 00 Days 00.00 Hrs | 000004.5 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 28.1875 | 1 | 0 | 0.375 | -0.5625 | -1 | 28
 | 19 | Rocky | 23 Days and 5.5 Hrs | 1 Day |  |  | 9 Hrs | 1 Day | 22 Day(s) and 4.5 Hour(s) |  |  |  | 0000023 Days and     5.5 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 000009 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 23.6875 | 1 | 0 | 0 | -1.125 | -1 | 22.5625
 | 20 | [NAME] | 6 Days and 5 Hrs | 1 Day |  |  | 7 Hrs | 1 Day | 5 Day(s) and 6 Hour(s) |  |  |  | 000006 Days and     5 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 000007 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 6.625 | 1 | 0 | 0 | -0.875 | -1 | 5.75
 | 21 | [NAME] | 3 Days and 0.5 Hrs | 1 Day |  |  | 20.5 Hrs |  | 1 Day(s) and 4 Hour(s) |  |  |  | 000003 Days and     0.5 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 0000020.5 Hrs 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 3.0625 | 1 | 0 | 0 | -2.5625 | 0 | 1.5
 | 22 | [NAME] | 8 Days and 3.5 Hrs | 1 Day |  |  | 9 Hrs | 1 Day | 7 Day(s) and 2.5 Hour(s) |  |  |  | 000008 Days and     3.5 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 000009 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 8.4375 | 1 | 0 | 0 | -1.125 | -1 | 7.3125
 | 23 | Edmund | 7 Days and 7 Hrs | 1 Day |  | 5 Hrs | 2.5 Hrs |  | 9 Day(s) and 1.5 Hour(s) |  |  |  | 000007 Days and     7 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 000005 Hrs 00 Days 00.00 Hrs | 000002.5 Hrs 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 7.875 | 1 | 0 | 0.625 | -0.3125 | 0 | 9.1875
 | 24 | Yolanda | 17 Days and 3 Hrs | 1 Day | 1 Day | 6 Hrs | 1 Hr |  | 20 Day(s) and 0 Hour(s) |  |  |  | 0000017 Days and     3 Hrs 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 000006 Hrs 00 Days 00.00 Hrs | 000001 Hr 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 17.375 | 1 | 1 | 0.75 | -0.125 | 0 | 20
 | 25 | [NAME] |  | 1 Day |  |  |  |  | 1 Day(s) and 0 Hour(s) |  |  |  | 00000 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 0 | 1 | 0 | 0 | 0 | 0 | 1
 | 26 | Rhea |  | 1 Day |  |  |  |  | 1 Day(s) and 0 Hour(s) |  |  |  | 00000 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 0 | 1 | 0 | 0 | 0 | 0 | 1
 | 27 | Mealou |  | 1 Day |  |  |  |  | 1 Day(s) and 0 Hour(s) |  |  |  | 00000 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 0 | 1 | 0 | 0 | 0 | 0 | 1
 | 28 | [NAME] |  | 1 Day |  |  |  |  | 1 Day(s) and 0 Hour(s) |  |  |  | 00000 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 0 | 1 | 0 | 0 | 0 | 0 | 1
 | 29 | Elvin |  | 1 Day |  |  |  |  | 1 Day(s) and 0 Hour(s) |  |  |  | 00000 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 0 | 1 | 0 | 0 | 0 | 0 | 1
 | 30 | Shon |  | 1 Day |  |  |  |  | 1 Day(s) and 0 Hour(s) |  |  |  | 00000 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 0 | 1 | 0 | 0 | 0 | 0 | 1
 | 31 | Elmo |  | 1 Day |  |  |  |  | 1 Day(s) and 0 Hour(s) |  |  |  | 00000 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 0 | 1 | 0 | 0 | 0 | 0 | 1
 | 32 | [NAME] |  | 1 Day |  |  | 2 Hrs |  | 0 Day(s) and 6 Hour(s) |  |  |  | 00000 00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 000002 Hrs 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 0 | 1 | 0 | 0 | -0.25 | 0 | 0.75
 | 33 |  |  |  |  |  |  |  | 0 Day(s) and 0 Hour(s) |  |  |  | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 34 |  |  |  |  |  |  |  | 0 Day(s) and 0 Hour(s) |  |  |  | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 35 | Nilo | 23 Days | 1 Day |  |  |  |  | 24 Day(s) and 0 Hour(s) |  |  |  | 0000023 Days  00 Days 00.00 Hrs | 000001 Day 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 23 | 1 | 0 | 0 | 0 | 0 | 24