Results 1 to 3 of 3

Find and calculate employee hours within date range

Threaded View

rockytop80 Find and calculate employee... 12-13-2011, 04:28 PM
Ricker090 Re: Find and calculate... 12-13-2011, 09:59 PM
rockytop80 Re: Find and calculate... 12-14-2011, 11:43 AM
  1. #1
    Registered User
    Join Date
    12-06-2011
    Location
    Maine
    MS-Off Ver
    Excel 2010
    Posts
    10

    Find and calculate employee hours within date range

    Hi all,

    I need to calculate the sum of an employee's hours worked during a given date range. I've attached an example of what I am working with. Shifts for all employees are on the first tab. Every time the name "Rose" appears during a week on the first tab I need it to add those hours together on the second tab. I know there's a formula to do this and I just can't quite get there. Thanks in advance for any help!

    Sample.xlsx
    Last edited by rockytop80; 12-14-2011 at 11:43 AM.

Thread Information

Users Browsing this Thread

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

Bookmarks

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