how do i create an auto calculating time card

[RobertReilly@MicroTechnology]

All I want is to create a simple time card that auto calculates time. IE:
1.in time,2.out to lunch 3. in from lunch, 4. out, then give me an answer in
hours and minutes worked, i have tried for weeks pouring through help files
and templates but nothing seems to work.

 

[Paul Ballou]

http://office.microsoft.com/en-us/results.aspx?Scope=TC&Query=timecard
try the templates here

http://www.cpearson.com/excel/overtime.htm
See this for help on creating a timesheet from scratch.
--
Paul Ballou
MVP Office
http://office.microsoft.com/clipart/default.aspx
http://office.microsoft.com/templates
http://office.microsoft.com/home

Control the things you can and Don't Worry about the things you can't
control.

"RobertReilly@MicroTechnology"

 

[Bob I]

1.in time-----> Cell A1
2.out to lunch -> Cell A2
3.in from lunch ->Cell A3
4.out------------>Cell A4
5. total time --->Cell A5 =(A2-A1)+(A4-A3)

Format all 5 Cells as Time 13:00 and enter all times as 24:00 hour clock