# Employee Timesheet; calculating +/- hours worked

1. ## Employee Timesheet; calculating +/- hours worked

Hi!

I'm trying to setup a basic Employee Timesheet on excel and I'm have an issue - I'm also not very proficient with excel. I'll attach my working Excel sheet to make thing clearer.

What I want to do is to automatically calculate the +/- hours worked by an employee; Column G
A full day would be 8.5 hours. So, if someone works 10.5 hours, then they have + 2 hours (2 hours overtime). Conversely, if someone only works 6.5 hours, then they have - 2 hours (2 hours minus/under-time).

Each +/- would be calculated for the respective day.

If there are any questions, then please let me know.

Also if there is a better way to enter in work times, then I'd appreciate all inputs. Inputs in regards to other issues are also very welcome.

Attached is my excel sheet.

Best,

2. ## Re: Employee Timesheet; calculating +/- hours worked

Take a look at this.

3. ## Re: Employee Timesheet; calculating +/- hours worked

Thanks for the help. Really appreciate it. I have a two more questions.
1. would it be possible to have the plus/minus columns in one?
2. Column "I" is "comment". I want a 8.5 hour day to be automatically entered in columns B,C,D,E, F (8:00;12:00;12:30;17:00:8:30) when I put either "Ferien" or Frei" in the "I" Column.

4. ## Re: Employee Timesheet; calculating +/- hours worked

1. Excel gives errors with negative times, that is why I create 2 colomns
2. You can't have formulas and values at the same time in the same cell

5. ## Re: Employee Timesheet; calculating +/- hours worked

Thanks for the quick response.

1. I understand
2. Is there a different way that I can do this? Say, by using a formula to represent "Ferien" of "Frei"?

6. ## Re: Employee Timesheet; calculating +/- hours worked

Maybe this way:
``Please Login or Register  to view this content.``

7. ## Re: Employee Timesheet; calculating +/- hours worked

This formula in G4 filled down will give +/- values in decimal format when formatted as general.
Formula:
`Please Login or Register  to view this content.`

I don't understand the language so the values in column H I can't help with.

Format F37 as [h]:mm

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1