Results 1 to 2 of 2

Thread: Total hours from multiple site schedules to employee roster.

  1. #1
    Neophyte If(Id<Prob,"Ask","Do")'s Avatar
    Join Date
    Jul 2019
    Posts
    1
    Articles
    0
    Excel Version
    365

    Question Total hours from multiple site schedules to employee roster.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    We have employees at multiple sites.

    Currently we have a schedule that spans a week for each site that auto totals hours worked.

    I would like to make a Single Doc with a sheet for each site that checks each sheet for the employees name then adds their total hours from each site to their true total.

    This will help my on duty supervisors quickly identify which employees are low on hours when seeking coverage for callouts and prevent overtime.

    I also will make each shift auto total the time worked based on start and end, ,total the weekly hours worked for each employee and the site etc. Pretty sure I can manage that though.

    If I can get a few pointers on how to create the formula criteria for totaling the hours then I can figure it out/apply it accross the board from there. I just got lost making my first attempt and now I have no idea where to start.

    I attached the spreadsheet in question.
    Attached Files Attached Files

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    768
    Articles
    0
    Excel Version
    Excel 2010 64bit
    How about adding together a SUMIF for each time sheet ?
    Your issue is going to be with the validation you've got, the employee names are not unique.
    Perhaps this will be of some use
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •