Time Sheet

  • Thread starter Thread starter G Port
  • Start date Start date
G

G Port

I need to set up a worksheet that will calculate the hours
work for each day. I enter start, lunch, and end and excel
gives total. EX:

Start Lunch End Total
8:00 1 hr 5:00 8

This is probally really easy, but I don't know enough
about excel to do it. Any help is much appreciated.

G Port
 
You need the following

Start| Out for Lunch| Back in From Lunch| Out|= Hours
Worked
Put each of these in there own column and use the
following formula. =(outforlunch-Start)+(Out-Back in for
lunch)=Hours worked
 
Thanks for the help, But I don't think I'm doing something
right.

I put in the formula, then when I tried to use it, it
didn't do what I wanted. I want to my spreadsheet to look
like the following

In / lch out / lch In / Out / Ttl
8:00 11:00 12:00 5:00 8

I can't get the format to give me this. I keep getting
1/17/1900 00:00 But the time will not change when I put in
8:00 it just stays the same. And the furmula gives
me .03666 (or something like that) for the answer. HELP!!!
 
You don't have the cells formatted properly.
Highlight the first 4 cells, right click and choose format cells. On the
number tab choose custom, scroll the list to find hh:mm:ss. Click OK and try
it again.
 
Hi G,

Try it this way:

A1 start time
B1 lunch out
C1 lunch in
D1 end time
F1 total hrs

In F1 enter this formula and format the cell as GENERAL:

=(D1-A1+(A1>D1)-(C1-B1))*24

Biff
 
Back
Top