Creating Bi-Weekly Time Sheet to Calculate Hours Worked
 

I am trying to create a time sheet for our staff to use bi-weekly (1st thru
15th and then another sheet for 16th through last day of month).
If our people enter at 8.00 and leave for lunch at 1.00 (pm), can anyone
tell me how to enter a formul which will give me the 5 hours that person
worked before departing for lunch?
Then they would re-enter at 1:30 and depart for the day at 4:00.
We're trying to keep it as simple as possible for our folks (we're a
non-profit) as most of our people don't grasp the military time.
Any suggestions will be greatly appreciated.

Creating Bi-Weekly Time Sheet to Calculate Hours Worked
 

=B2-A2+0.5*(B2<A2)

With 8:00 entereed into A2, and 1:00 entered into cell B2, will give 5:00

If you want hours (so that you can multiply by pay rate, etc), use

=(B2-A2+0.5*(B2<A2))*24


HTH,
Bernie
MS Excel MVP


"nbslarson" wrote in message
...
I am trying to create a time sheet for our staff to use bi-weekly (1st thru
15th and then another sheet for 16th through last day of month).
If our people enter at 8.00 and leave for lunch at 1.00 (pm), can anyone
tell me how to enter a formul which will give me the 5 hours that person
worked before departing for lunch?
Then they would re-enter at 1:30 and depart for the day at 4:00.
We're trying to keep it as simple as possible for our folks (we're a
non-profit) as most of our people don't grasp the military time.
Any suggestions will be greatly appreciated.

Creating Bi-Weekly Time Sheet to Calculate Hours Worked
 

Thank you, Bernie. I appreciate your help very much.

Gayla

"Bernie Deitrick" wrote:

=B2-A2+0.5*(B2<A2)

With 8:00 entereed into A2, and 1:00 entered into cell B2, will give 5:00

If you want hours (so that you can multiply by pay rate, etc), use

=(B2-A2+0.5*(B2<A2))*24


HTH,
Bernie
MS Excel MVP


"nbslarson" wrote in message
...
I am trying to create a time sheet for our staff to use bi-weekly (1st thru
15th and then another sheet for 16th through last day of month).
If our people enter at 8.00 and leave for lunch at 1.00 (pm), can anyone
tell me how to enter a formul which will give me the 5 hours that person
worked before departing for lunch?
Then they would re-enter at 1:30 and depart for the day at 4:00.
We're trying to keep it as simple as possible for our folks (we're a
non-profit) as most of our people don't grasp the military time.
Any suggestions will be greatly appreciated.