# how do i calculate no. of hours in excel

#### ajishkumar

##### New Member
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>

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

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

Replies
3
Views
682
Replies
5
Views
282
Replies
1
Views
322
Replies
5
Views
793
Replies
0
Views
217

1,136,339
Messages
5,675,195
Members
419,553
Latest member
hanahass

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back