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. #2
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    157

    Re: Find and calculate employee hours within date range

    I meant to get to this sooner. Sorry for the delay.

    You can use this formula in cell B2 of the Winter Instructors tab. Use it to autofill down and across your table.

    =SUMIFS(Programs!$I:$I,Programs!$A:$A,">="&VALUE(LEFT('Winter Instructors'!B$1,8)),Programs!$A:$A,"<="&VALUE(RIGHT('Winter Instructors'!B$1,8)),Programs!$E:$E,'Winter Instructors'!$A2)+SUMIFS(Programs!$I:$I,Programs!$A:$A,">="&VALUE(LEFT('Winter Instructors'!B$1,8)),Programs!$A:$A,"<="&VALUE(RIGHT('Winter Instructors'!B$1,8)),Programs!$F:$F,'Winter Instructors'!$A2)
    I've also attached a copy with the function already populated across the cells.
    Attached Files Attached Files

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