subtracting time hours, how to do that

[kathelleen]

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.

 

[texasalynn]

so if you have time in your spreadsheet without the am/pm

Excel Workbook
	B
3	8:00
4	5:00
Sheet1

Excel 2003
then you try to do math on those it would fail

Excel Workbook
	B
3	8:00
4	5:00
5	########
Sheet1

Excel 2003

Cell Formulas
Range	Formula
B5	=+B4-B3

you would need to format the cells as either military time or include the am/pm

Excel Workbook
	B	C
3	8:00	8:00 AM
4	17:00	5:00 PM
5	9:00	9:00
Sheet1

Excel 2003

Cell Formulas
Range	Formula
B5	=+B4-B3
C5	=+C4-C3

 

[JimSnyder]

I haven't done it in Excel, but this is from Excel help:
http://office.microsoft.com/assista...990&lcid=1033&CTT=5&origin=HP005200127&ver=11

 

[kathelleen]

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.