Results 1 to 5 of 5

Formulas to tally total hours for each staff from schedule

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-02-2013
    Location
    West Palm beach, Fl
    MS-Off Ver
    Excel 2010
    Posts
    113

    Formulas to tally total hours for each staff from schedule

    Hello,

    I have a weekly schedule template I have put together for our nurses. I need a formula that will tally the total hours each employee has worked based off of their schedule for that week. I've tried sumproduct, but because of the format of my schedule (or my limited understanding of the formula), it's not working for me. Maybe stringing some sumifs together to compensate for the several columns involved? I dunno. Any help would be greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate total hours per week per schedule
    By rizmomin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-14-2013, 11:28 PM
  2. Replies: 5
    Last Post: 08-19-2013, 06:37 PM
  3. Replies: 0
    Last Post: 02-07-2013, 08:42 PM
  4. Calculating total shift hours in a schedule
    By mgandy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-30-2008, 10:52 AM
  5. Total schedule hours
    By dude2125 in forum Excel General
    Replies: 9
    Last Post: 12-14-2007, 09:54 AM

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