# 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,  Register To Reply

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

Take a look at this.  Register To Reply

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.  Register To Reply

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  Register To Reply

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"?  Register To Reply

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

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

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  Register To Reply