Creating Bi-Weekly Time Sheet to Calculate Hours Worked

Giganews Newsgroups
Subject: Creating Bi-Weekly Time Sheet to Calculate Hours Worked
Posted by:  nbslarson
Date: Wed, 29 Aug 2007

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.

Replies