+ Reply to Thread
Results 1 to 1 of 1

Allocating a staff based on the time they finish task keepin in mind start time of task.

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2003

    Unhappy Allocating a staff based on the time they finish task keepin in mind start time of task.

    I follow this forum regularly and I need help. To be frank I am not able to decide whether I have to take the Macro route (don’t know much about Macro’s though) or the normal formulas will work.

    I have two columns. The first column(A) has date+time and defines when the work will begin. Column (B) has times when the work will end. I have staff whose numbers range from 1 to 14. I want to allocate the staff based on the work finish times. For example staff 1 finishes work at 23:57:00. So he can be allocated to a work which will begin at 00:02:00. The same happens for all staff between 1 to 14. Attached is a sample work sheet.

    Basically trying to increase efficiency of staff utilization based on their job finish times in comparison with the job start times.

    Thank you,

    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate start date & time of task (working hours)
    By kaaver in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-30-2016, 10:56 AM
  2. Calculate finish time given start time, working hours and job duration
    By swanseaexcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-23-2012, 03:00 PM
  3. Ready Time, Start Time, Finish Time by user
    By teguigala in forum Excel General
    Replies: 3
    Last Post: 02-15-2012, 03:34 PM
  4. Is there a way to create a start task with task id 0
    By Love Excel in forum Excel General
    Replies: 0
    Last Post: 06-21-2009, 08:38 PM
  5. [SOLVED] template or formula for start time -finish time -total hours ple
    By cc in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-27-2006, 01:10 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1