how do i calculate no. of hours in excel

[ajishkumar]

I have used SUM function to calculate total no. of hrs logged. But it's not giving the exact no. of hours that I logged.

How do I calculate the total no. of hours in excel? The screen shot is attached.

Is there is any formula in excel which takes care of this? I am getting 12.00 hrs. But the actual result should be 36 hrs.

Thanks,
Ajish

<table x:str="" style="border-collapse: collapse; width: 192pt;" width="256" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64" span="4"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt; width: 48pt;" width="64" height="17">date</td> <td class="xl66" style="width: 48pt;" width="64">from</td> <td class="xl66" style="width: 48pt;" width="64">to</td> <td class="xl66" style="width: 48pt;" width="64">total</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" x:num="62" align="right" height="17">02-Mar</td> <td class="xl64" x:num="0.54166666666666663" align="right">13:00</td> <td class="xl64" x:num="0.58333333333333337" align="right">14:00</td> <td class="xl64" x:num="4.1666666666666741E-2" x:fmla="=C2-B2" align="right">01:00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" x:num="40239" align="right" height="17">02-Mar</td> <td class="xl64" x:num="0.60416666666666663" align="right">14:30</td> <td class="xl64" x:num="0.6875" align="right">16:30</td> <td class="xl64" x:num="8.333333333333337E-2" x:fmla="=C3-B3" align="right">02:00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" x:num="40239" align="right" height="17">02-Mar</td> <td class="xl64" x:num="0.6875" align="right">16:30</td> <td class="xl64" x:num="0.77083333333333337" align="right">18:30</td> <td class="xl64" x:num="8.333333333333337E-2" x:fmla="=C4-B4" align="right">02:00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" x:num="40240" align="right" height="17">03-Mar</td> <td class="xl64" x:num="0.41666666666666669" align="right">10:00</td> <td class="xl64" x:num="0.6875" align="right">16:30</td> <td class="xl64" x:num="0.27083333333333331" x:fmla="=C5-B5" align="right">06:30</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" x:num="40240" align="right" height="17">03-Mar</td> <td class="xl64" x:num="0.70833333333333337" align="right">17:00</td> <td class="xl64" x:num="0.77083333333333337" align="right">18:30</td> <td class="xl64" x:num="6.25E-2" x:fmla="=C6-B6" align="right">01:30</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" x:num="40241" align="right" height="17">04-Mar</td> <td class="xl64" x:num="0.45833333333333331" align="right">11:00</td> <td class="xl64" x:num="0.70833333333333337" align="right">17:00</td> <td class="xl64" x:num="0.25" x:fmla="=C7-B7" align="right">06:00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" x:num="40241" align="right" height="17">04-Mar</td> <td class="xl64" x:num="0.70833333333333337" align="right">17:00</td> <td class="xl64" x:num="0.75" align="right">18:00</td> <td class="xl64" x:num="4.166666666666663E-2" x:fmla="=C8-B8" align="right">01:00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" x:num="40242" align="right" height="17">05-Mar</td> <td class="xl64" x:num="0.41666666666666669" align="right">10:00</td> <td class="xl64" x:num="0.70833333333333337" align="right">17:00</td> <td class="xl64" x:num="0.29166666666666669" x:fmla="=C9-B9" align="right">07:00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" x:num="40242" align="right" height="17">05-Mar</td> <td class="xl64" x:num="0.70833333333333337" align="right">17:00</td> <td class="xl64" x:num="0.75" align="right">18:00</td> <td class="xl64" x:num="4.166666666666663E-2" x:fmla="=C10-B10" align="right">01:00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" x:num="40243" align="right" height="17">06-Mar</td> <td>
</td> <td>
</td> <td class="xl64">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" x:num="40244" align="right" height="17">07-Mar</td> <td class="xl64" x:num="0.41666666666666669" align="right">10:00</td> <td class="xl64" x:num="0.70833333333333337" align="right">17:00</td> <td class="xl64" x:num="0.29166666666666669" x:fmla="=C12-B12" align="right">07:00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" x:num="40244" align="right" height="17">07-Mar</td> <td class="xl64" x:num="0.70833333333333337" align="right">17:00</td> <td class="xl64" x:num="0.75" align="right">18:00</td> <td class="xl64" x:num="4.166666666666663E-2" x:fmla="=C13-B13" align="right">01:00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td class="xl64">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>Total</td> <td class="xl65" x:num="1.5" align="right">12:00</td> </tr> </tbody></table>

 

[PaddyD]

format the cell [hh]:mm - the brackets are for elapsed time calculations

 

[ajishkumar]

Wow. great simple tip Paddy.