|
I hope someone can help me make a formula that will calculate a 40 hour week timesheet, this was made in excel minus the borders. When I enter times such as 8:00 am and 4:30 pm, I need it to say 8.5 hours under total hours, there's an example of what I need it to look like, using a formula. I need to calculate overtime too. Please help, I need it for my job, thanks
Employee Timesheet
Employee Name:
Start Date:
Date | Start Time | End time | Job | Description
Monday 8:00 am 4:00 pm
Tuesday
Wednesday
Thursday
Friday
Saturday
WEEKLY TOTAL
Total Hours: 8.5
Regular Hours 40
Overtime hours
Last edited by ComputerCon; 06-14-2005 at 12:07 AM..
|
