subtracting time hours, how to do that

kathelleen

New Member
Joined
Mar 10, 2011
Messages
2
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.
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
so if you have time in your spreadsheet without the am/pm
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
 

kathelleen

New Member
Joined
Mar 10, 2011
Messages
2
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,721
Messages
5,597,752
Members
414,171
Latest member
12Rev79

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top