I want to creat an excel spreadsheet where I can add time.  For
example lets say I clock in at 2:00 (in this format) in the afternoon
and I take a lunch at 6:00.  I return to work at 6:30 and I leave at
9:00.  That's 6 and a half hours I have worked.  How would I be able
to do this in excel?

henryfranco,

The commenters below gave you many ideas to work on your Excel
problem. I would like to also show you a resource where you can anser
all your excel questions.
http://www.exceltip.com/search/Time.html

Excel Tip gives you a comprehensive search forum to locate tips and
ideas on how to do specific functions in Excel. For example, the URL I
listed there gives you things you can do with time in Excel, and
answers your question right here.
http://www.exceltip.com/st/Calculating_the_difference_between_hours_in_Microsoft_Excel/97.html
http://www.exceltip.com/images/screenshots/97.gif ( Screenshot)

"Calculating the difference between hours in Microsoft Excel
Calculate an employee's working hours. In the screen shot, notice the
format in Cells E4:E8 is hh:mm. The number 1 in the formula IF
represents a time value that exceeds 24 hours in a day.
See line 5 in the example. An employee named Mark arrived at work at
23:00 in the evening and finished work at 7:00 the next morning. The
result is calculated as 8:00 working hours."

There you go henryfranco. I hope this helps you with this question and
all your Excel needs. If this answer requires further explanation,
please request clarification before rating it, and I'll be happy to
look into this further.


Nenna-GA
Google Answers Researcher

you have to use .25 .50 .75 for 15 30 and 45 minutes

=(HOUR(B1) - HOUR(A1)) + (MINUTE(B1) - MINUTE(A1))*60

A1 = cell with time in
B1 = cell with time out

It's even easier then that:

in cells a1 to d1 key the following:

in      lunch   back    home
14:00	18:00	18:30	21:00

formula to calculate the total hours worked is:
=B1-A1+D1-C1

Good luck.

or use this:
Column A in A1 thru a5 insert; format the column as general
Column B in B1 thru B5 enter times; format the column as time 1:30:50
PM you can use Ctr+Shift+: to enter the time if you are doing it in
real time.
in Column C   C2:=B2-B1  C3:=B3-B2  C5: =(B4-B1)-C3  enter  the
following formulas; format coulm C with time 1:30
now you have it other clock in and out times can be added for breaks
or other things as needed.  Hope this helps

clock in               2:31:00 PM
lunch clock out        4:36:00 PM        =B2-B1
Lunch clock in         5:08:00 PM        =B3-B2
Clock out              9:31:00 PM
Hours worked                             =(B4-B1)-C3

Unless your hours span across midnight, then incorporae something like
" =(C4-C3+IF(C3>C4,1))+(C6-C5+IF(C5>C6,1)) "

c3=Start 1
c4=End 1
c5=Start 2
c6=End 2