How to subtract a lunch break from total hrs worked in timesheet
 

I am setting up a time sheet in excel. For each day of the week, the end user
enters Time in and Time out. GA has a 30 min lunch break that I need to
subtract out of the total time for the day. I would like the end user to be
able to insert more that 30 mins if necessary.
I've checked the templates on the MS web, but none subtract a time.
Thanks,
Zoe Marshall

How to subtract a lunch break from total hrs worked in timesheet
 

The easiest way to do this is to format the the cells to hold a time
value (13:00) an example would be to set up A1 - D1 to hold time
values have A1 be your start time of 07:30, B1 be your ending time of
15:30 (3:30pm), C1 be your lunch break 0:45 (45 minutes). The code in
D1 would be "=(B1-C1)-A1" this would give you the hours worked. The
only draw back is the use of military time (07:30, 15:30 and so on).


On Mon, 25 Oct 2004 17:29:04 -0700, "ZoeMarshall"
wrote:

I am setting up a time sheet in excel. For each day of the week, the end user
enters Time in and Time out. GA has a 30 min lunch break that I need to
subtract out of the total time for the day. I would like the end user to be
able to insert more that 30 mins if necessary.
I've checked the templates on the MS web, but none subtract a time.
Thanks,
Zoe Marshall

How to subtract a lunch break from total hrs worked in timesheet
 

Rather than committing to maintain an excel-based timesheet
application for the rest of your life, why not install the free one
from http://journyx.com/newsg?
It's web-based, tracks time, expenses and mileage - automates payroll,
billing and project management, and it's free.

CDrews wrote in message . ..
The easiest way to do this is to format the the cells to hold a time
value (13:00) an example would be to set up A1 - D1 to hold time
values have A1 be your start time of 07:30, B1 be your ending time of
15:30 (3:30pm), C1 be your lunch break 0:45 (45 minutes). The code in
D1 would be "=(B1-C1)-A1" this would give you the hours worked. The
only draw back is the use of military time (07:30, 15:30 and so on).


On Mon, 25 Oct 2004 17:29:04 -0700, "ZoeMarshall"
wrote:

I am setting up a time sheet in excel. For each day of the week, the end user
enters Time in and Time out. GA has a 30 min lunch break that I need to
subtract out of the total time for the day. I would like the end user to be
able to insert more that 30 mins if necessary.
I've checked the templates on the MS web, but none subtract a time.
Thanks,
Zoe Marshall