Spreadsheet: 83805d1283851941-want-to-calculate-8-hours-as-one-working-day-744688_shraddhasj
Sheet: Sheet1

 |  |  | 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 | xxx | 28 Days and 4 Hrs | 1 day |  | 4 hours |  |  | 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 hours 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 | yyy | 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 | zzz | 4 days and 5.5 hours | 1 day |  | 6.5 hrs | 21.5 hrs |  | 3 Day(s) and 6.5 Hour(s) |  |  |  | 000004 days and     5.5 hours 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 | 0000021.5 hrs 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 4.6875 | 1 | 0 | 0.8125 | -2.6875 | 0 | 3.8125
 | 4 |  | 10.25 hours |  |  |  |  |  | 1 Day(s) and 2.25 Hour(s) |  |  |  | 0000010.25 hours 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 | 1.28125 | 0 | 0 | 0 | 0 | 0 | 1.28125
 | 5 |  | 1 day |  |  |  | 7 hrs |  | 0 Day(s) and 1 Hour(s) |  |  |  | 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 | 000007 hrs 00 Days 00.00 Hrs | 00000 00 Days 00.00 Hrs | 1 | 0 | 0 | 0 | -0.875 | 0 | 0.125
 | 6 |  |  |  |  |  |  |  |  |  |  |  | 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
 | 7 |  |  |  |  |  |  |  |  |  |  |  | 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
 | 8 |  |  |  |  |  |  |  |  |  |  |  | 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
 | 9 |  |  |  |  |  |  |  |  |  |  |  | 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
 | 10 |  |  |  |  |  |  |  |  |  |  |  | 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
 | 11 |  |  |  |  |  |  |  |  |  |  |  | 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
 | 12 |  |  |  |  |  |  |  |  |  |  |  | 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