how do i create an auto calculating time card

  • Thread starter RobertReilly@MicroTechnology
  • Start date
R

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.
 
B

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
 
Top