# subtracting time hours, how to do that

#### kathelleen

##### New Member
I am asked in my office to keep track of extra hours and sick/vacation days.
I would like to use the excel workbook, but I am not at all to swavy with it. I would like to add and subtract hours, but with a few experimenting, I am not successful in doing so. I can send you and email of what I have done to show what I﻿ am talking about. But I could use some guidance. Thanks you.

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Excel Workbook
B
38:00
45:00
Sheet1
Excel 2003
then you try to do math on those it would fail
Excel Workbook
B
38:00
45:00
5########
Sheet1
Excel 2003
Cell Formulas
RangeFormula
B5=+B4-B3

you would need to format the cells as either military time or include the am/pm
Excel Workbook
BC
38:008:00 AM
417:005:00 PM
59:009:00
Sheet1
Excel 2003
Cell Formulas
RangeFormula
B5=+B4-B3
C5=+C4-C3

Thanks for your help, but I am looking for something like this:
in row a I will have 5, based on the end of the week payday, entries for the month. But as I enter in each one, there will be times that I have to subtract hours. Basically like this:
<table width="280" border="0" cellpadding="0" cellspacing="0"><col style="width: 42pt;" width="56"> <col style="width: 42pt;" width="56" span="3"> <col style="width: 42pt;" width="56"> <tbody><tr style="height: 11.25pt;" height="15"> <td class="xl22" style="height: 11.25pt; width: 42pt;" width="56" align="right" height="15">1/7/2011</td> <td style="width: 42pt;" width="56" align="right">2.17</td> <td style="width: 42pt;" width="56" align="right">3</td> <td style="width: 42pt;" width="56" align="right">0</td> <td class="xl23" style="width: 42pt;" width="56" align="right">0.20</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl22" style="height: 11.25pt;" align="right" height="15">1/14/2011</td> <td align="right">2.05</td> <td align="right">2</td> <td align="right">0</td> <td class="xl23" align="right">0.00</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl22" style="height: 11.25pt;" align="right" height="15">1/21/2011</td> <td align="right">0.41</td> <td align="right">2</td> <td align="right">0</td> <td align="right">0</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl22" style="height: 11.25pt;" align="right" height="15">1/28/2011</td> <td align="right">-3.24</td> <td align="right">0</td> <td align="right">0</td> <td class="xl23" align="right">1.45</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl24" style="height: 11.25pt;" height="15">total</td> <td align="right">1.39</td> <td align="right">7</td> <td align="right">0</td> <td class="xl23" align="right">1.65</td> </tr> </tbody></table>
I ended up doing the above using the decimal system, but I am asked to use the semi colon system. When I begin to use the :, I am not able to subtract the hours.

Replies
4
Views
290
Replies
1
Views
93
Replies
1
Views
53
Replies
18
Views
436
Replies
23
Views
280

1,203,631
Messages
6,056,432
Members
444,864
Latest member
Thundama

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