Setting work time at Excel

[Thiyagu]

Hi ,

Anyone can help me on below problem's,,.,I did attached examples below..

<table x:str="" style="border-collapse: collapse; width: 479pt;" border="0" cellpadding="0" cellspacing="0" width="638"><col style="width: 99pt;" width="132"> <col style="width: 59pt;" width="78"> <col style="width: 96pt;" width="128"> <col style="width: 114pt;" width="152"> <col style="width: 111pt;" width="148"> <tbody><tr style="height: 13.5pt;" height="18"> <td class="xl24" style="height: 13.5pt; width: 99pt;" height="18" width="132">My working time</td> <td style="width: 59pt;" width="78">7am to 7pm</td> <td style="width: 96pt;" width="128">12 hrs</td> <td style="width: 114pt;" width="152">
</td> <td style="width: 111pt;" width="148">
</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl24" style="height: 13.5pt;" height="18">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 40.5pt;" height="54"> <td class="xl28" style="height: 40.5pt; width: 99pt;" height="54" width="132">Date Start</td> <td class="xl29" style="width: 59pt;" width="78">Time Work</td> <td class="xl29" style="width: 96pt;" width="128">Days work (Time work Divide 24)</td> <td class="xl29" style="width: 114pt;" width="152">Date stop (Date Start + Days Work)</td> <td class="xl29" style="width: 111pt;" width="148">Result</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl25" style="height: 13.5pt;" x:num="40408.291666666664" height="18">8/18/10 7:00 AM</td> <td class="xl26" x:num="">12</td> <td class="xl27" x:num="0.5" x:fmla="=B4/24">0.50 </td> <td class="xl25" x:num="40408.791666666664" x:fmla="=A4+C4">8/18/10 7:00 PM</td> <td>O.K</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl25" style="height: 13.5pt;" x:num="40408.291666666664" height="18">8/18/10 7:00 AM</td> <td class="xl26" x:num="">13</td> <td class="xl27" x:num="0.54166666666666663" x:fmla="=B5/24">0.54 </td> <td class="xl25" x:num="40408.833333333328" x:fmla="=A5+C5">8/18/10 8:00 PM</td> <td>Getting wrong Result</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl25" style="height: 13.5pt;" x:num="40408.291666666664" height="18">8/18/10 7:00 AM</td> <td class="xl26" x:num="">13</td> <td class="xl27" x:num="0.54166666666666663" x:fmla="=B6/24">0.54 </td> <td class="xl25" x:num="40409.333333333336">8/19/10 8:00 AM</td> <td>Expecting Result</td> </tr> </tbody></table>

 

[Thiyagu]

Hi Sir,

Thanks a lot...you had provide me want i want ..Really thanks again...
Your formula work well...

Again thanks a lot...