Facing some problem to making an attendance sheet

[jollysalman]

<table style="width: 1281pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="1707"> <colgroup> <col style="width: 89pt;" width="119" span="4"> <col style="width: 62pt;" width="82"> <col style="width: 75pt;" width="100"> <col style="width: 48pt;" width="64"> <col style="width: 75pt;" width="100"> <col style="width: 48pt;" width="64" span="2"> <col style="width: 133pt;" width="177"> <col style="width: 152pt;" width="202"> <col style="width: 48pt;" width="64" span="3"> <col style="width: 140pt;" width="186"> </colgroup><tbody> <tr style="height: 30pt;" height="40"> <td class="xl70" style="border: 0.5pt solid windowtext; width: 89pt; height: 30pt; background-color: rgb(191, 191, 191);" width="119" height="40">Attendance
Date</td> <td class="xl70" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; width: 89pt; background-color: rgb(191, 191, 191);" width="119"> </td> <td class="xl70" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; width: 89pt; background-color: rgb(191, 191, 191);" width="119"> </td> <td class="xl70" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; width: 89pt; background-color: rgb(191, 191, 191);" width="119">Off Time</td> <td class="xl71" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; width: 62pt; background-color: rgb(191, 191, 191);" width="82">Shift</td> <td class="xl70" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; width: 75pt; background-color: rgb(191, 191, 191);" width="100">Date
In.</td> <td class="xl70" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; width: 48pt; background-color: rgb(191, 191, 191);" width="64">Time
in.</td> <td class="xl70" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; width: 75pt; background-color: rgb(191, 191, 191);" width="100">Date
Out</td> <td class="xl70" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; width: 48pt; background-color: rgb(191, 191, 191);" width="64">Time
Out</td> <td class="xl70" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; width: 48pt; background-color: rgb(191, 191, 191);" width="64">Work
Hr.</td> <td class="xl70" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; width: 133pt; background-color: rgb(191, 191, 191);" width="177">Late
Arr.</td> <td class="xl70" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; width: 152pt; background-color: rgb(191, 191, 191);" width="202">Over
time</td> <td class="xl70" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; width: 48pt; background-color: rgb(191, 191, 191);" width="64">Early
Hr.</td> <td class="xl70" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; width: 48pt; background-color: rgb(191, 191, 191);" width="64">Break
Hr.</td> <td class="xl70" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; width: 48pt; background-color: rgb(191, 191, 191);" width="64">Remarks</td> <td class="xl72" style="border-width: medium; border-style: none; border-color: rgb(236, 233, 216) rgb(236, 233, 216) rgb(236, 233, 216) windowtext; width: 140pt; background-color: transparent;" width="186"> </td></tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="border-width: medium 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext; height: 15pt; background-color: transparent;" align="right" height="20">Fri, 01 Jul, 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">9:15</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">17:45</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">07:15</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">9:15 - 17:45</td> <td class="xl68" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">01-Jul- 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">10:00</td> <td class="xl68" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">01-Jul- 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">18:13</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">6:58</td> <td class="xl69" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">-00:45</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">=IF(I2>"18:30",(J2-D2),0)+B2-G2</td> <td class="xl65" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;"> </td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">1:15</td> <td class="xl65" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">Late In</td> <td class="xl73" style="border-width: medium; border-style: none; border-color: rgb(236, 233, 216) rgb(236, 233, 216) rgb(236, 233, 216) windowtext; background-color: transparent;">I want to 00:00 in this Cell L2</td></tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="border-width: medium 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext; height: 15pt; background-color: transparent;" align="right" height="20">Sat, 02 Jul, 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">9:15</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">18:00</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">08:00</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">9:15 - 18:00</td> <td class="xl68" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">02-Jul- 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">9:10</td> <td class="xl68" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">02-Jul- 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">18:10</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">8:15</td> <td class="xl69" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">=IF(I3>"18:30",D3-J3,G3-B3)</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">0:05</td> <td class="xl65" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;"> </td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">00:45</td> <td class="xl65" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;"> </td> <td class="xl73" style="border-width: medium; border-style: none; border-color: rgb(236, 233, 216) rgb(236, 233, 216) rgb(236, 233, 216) windowtext; background-color: transparent;">I want to 00:00 in this Cell K3</td></tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="border-width: medium 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext; height: 15pt; background-color: transparent;" align="right" height="20">Sun, 03 Jul, 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">00:00</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">00:00</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">00:00</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">00:00 - 00:00</td> <td class="xl68" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">03-Jul- 2011</td> <td class="xl65" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;"> </td> <td class="xl68" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">03-Jul- 2011</td> <td class="xl65" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;"> </td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="middle">########</td> <td class="xl69" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">-00:00</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">0:00</td> <td class="xl65" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;"> </td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">00:45</td> <td class="xl65" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">offday</td> <td class="xl72" style="border-width: medium; border-style: none; border-color: rgb(236, 233, 216) rgb(236, 233, 216) rgb(236, 233, 216) windowtext; background-color: transparent;"> </td></tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="border-width: medium 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext; height: 15pt; background-color: transparent;" align="right" height="20">Mon, 04 Jul, 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">9:15</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">18:00</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">08:00</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">9:15 - 18:00</td> <td class="xl68" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">04-Jul- 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">10:10</td> <td class="xl68" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">04-Jul- 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">18:16</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">7:21</td> <td class="xl69" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">-00:55</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="middle">############################</td> <td class="xl65" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;"> </td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">00:45</td> <td class="xl65" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;"> </td> <td class="xl72" style="border-width: medium; border-style: none; border-color: rgb(236, 233, 216) rgb(236, 233, 216) rgb(236, 233, 216) windowtext; background-color: transparent;"> </td></tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="border-width: medium 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext; height: 15pt; background-color: transparent;" align="right" height="20">Tue, 05 Jul, 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">9:15</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">18:00</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">08:00</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">9:15 - 18:00</td> <td class="xl68" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">05-Jul- 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">9:10</td> <td class="xl68" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">05-Jul- 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">18:30</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">8:35</td> <td class="xl69" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="middle">########################</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">0:05</td> <td class="xl65" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;"> </td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">00:45</td> <td class="xl65" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;"> </td> <td class="xl72" style="border-width: medium; border-style: none; border-color: rgb(236, 233, 216) rgb(236, 233, 216) rgb(236, 233, 216) windowtext; background-color: transparent;"> </td></tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="border-width: medium 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext; height: 15pt; background-color: transparent;" align="right" height="20">Wed, 06 Jul, 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">9:15</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">18:00</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">08:00</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">9:15 - 18:00</td> <td class="xl68" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">06-Jul- 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">10:15</td> <td class="xl68" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">06-Jul- 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">18:37</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">7:37</td> <td class="xl69" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">-01:00</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">=IF(I7>"18:30",(J7-D7),0)+B7-G7</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;"> </td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">00:45</td> <td class="xl65" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;"> </td> <td class="xl73" style="border-width: medium; border-style: none; border-color: rgb(236, 233, 216) rgb(236, 233, 216) rgb(236, 233, 216) windowtext; background-color: transparent;">I want to in 00:37 this Cell L7</td></tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="border-width: medium 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext; height: 15pt; background-color: transparent;" align="right" height="20">Thu, 07 Jul, 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">9:15</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">18:00</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">08:00</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">9:15 - 18:00</td> <td class="xl68" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">07-Jul- 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">9:15</td> <td class="xl68" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">07-Jul- 2011</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">19:00</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">9:00</td> <td class="xl69" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" align="right">-00:00</td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">=IF(I8>"18:30",(J8-D8),0)+B8-G8</td> <td class="xl65" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;"> </td> <td class="xl67" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;">00:45</td> <td class="xl65" style="border-width: medium 0.5pt 0.5pt medium; border-style: none solid solid none; border-color: windowtext; background-color: transparent;"> </td> <td class="xl73" style="border-width: medium; border-style: none; border-color: rgb(236, 233, 216) rgb(236, 233, 216) rgb(236, 233, 216) windowtext; background-color: transparent;">I want to in 01:00 this Cell L8</td></tr></tbody></table>

 

[jollysalman]

I am facing some problem to making an attendance sheet. Please see following required and recommend me as soon as possible.

<Pre>
Cell L2 I want to 00:00 in this Cell L2
Cell K3 I want to 00:00 in this Cell K3
Cell L7 I want to in 00:37 this Cell L7
Cell L8 I want to in 01:00 this Cell L8
</Pre>

 

[jollysalman]

do u have any problem to understanding the above request so please reply me

 

[jollysalman]

Need your help...

 

[jollysalman]

Please helpme