Calculating total overtime hours worked per employee

**markjmcl** · 09-07-2011, 06:34 PM

I need to calculate the total number of overtime hours worked in a 4 week period using employee numbers to identify the worker. Each employee may have multiply entries.

I have absolutely no idea how to get the calcuation to look through the spreadsheet looking for duplicate employee numbers and totalling their hours. (Full spreadsheet can have over 1000 entries)

Any help would be much appreciated. I have attached a sample spreadsheet.

Thanks

**jeffreybrown** · 09-07-2011, 06:39 PM

Hello & Welcome to the Board,

Like this example maybe...

**markjmcl** · 09-07-2011, 06:48 PM

Thanks for the lightning quick response. That has worked perfectly!

Many thanks for your help!

**jeffreybrown** · 09-07-2011, 06:49 PM

You're welcome...Glad to have helped

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save