Really need assistance . I have a workbook that calculates start and finish dates of task based on hours available to work. The problem that I have is that it assigns all hours to the first job instead of to different task. If I have 5 workers I want 5 jobs going simultaneously once one worker is finish I want the next job to start. Also,the max number of hours per day cannot exceed 6. So if a task takes 18hours it will span 3 days.
Formula I currently use: =MIN((SourceData!$F2-SUM($A3:A3)), (MaxHrsPerDay-SUM(C$2:C2)))
Formula I currently use: =MIN((SourceData!$F2-SUM($A3:A3)), (MaxHrsPerDay-SUM(C$2:C2)))
Last edited: