| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Total hours worked during workdays within given shift time. | Excel Discussion (Misc queries) | |||
| Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
| how do i set up a weekly scedule in excel to track time worked | Excel Worksheet Functions | |||
| List employees with hours worked, weekly, quarterly, and annually | New Users to Excel | |||
| CALCULATE HOURS WORKED | Excel Discussion (Misc queries) | |||
Hybrid Mode
