+ Reply to Thread
Results 1 to 8 of 8

Excel Required Headcount

  1. #1
    Registered User
    Join Date
    06-07-2023
    Location
    Pampanga, Philippines
    MS-Off Ver
    2021
    Posts
    4

    Excel Required Headcount

    Hi guys i need help in getting the required headcount for interval
    Capture.PNG
    instruction :
    1. Required headcount per interval if each agent should only have a maximum of 3 chat concurrency based on the Chats in progress in Table 2.
    Attached Files Attached Files
    Last edited by saycet15; 06-07-2023 at 09:31 PM.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Excel Required Headcount

    there is no Table2 or even Table1
    there is no example of expected result

  3. #3
    Registered User
    Join Date
    06-07-2023
    Location
    Pampanga, Philippines
    MS-Off Ver
    2021
    Posts
    4

    Re: Excel Required Headcount

    Hi, image is actually the table 2

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Excel Required Headcount

    Quote Originally Posted by sandy666 View Post
    tthere is no example of expected result
    what about this?

  5. #5
    Registered User
    Join Date
    06-07-2023
    Location
    Pampanga, Philippines
    MS-Off Ver
    2021
    Posts
    4

    Re: Excel Required Headcount

    This is actually the screenshot of my original problem please check thanks

    3.PNG

    i just need the required headcount i don't know how to calculate if there was a interval time.

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Excel Required Headcount

    post the same but not in the pictures, use excel file
    and still I don't see expected result
    Last edited by sandy666; 06-07-2023 at 09:30 PM.

  7. #7
    Registered User
    Join Date
    06-07-2023
    Location
    Pampanga, Philippines
    MS-Off Ver
    2021
    Posts
    4

    Re: Excel Required Headcount

    I added a attached file please check " sheet.xlsx‎ "
    thank you much appreciated if you can help me
    this is the only instruction provided to me

  8. #8
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,435

    Re: Excel Required Headcount

    Welcome to this forum.
    I don't know how to calculate if there was a interval time.
    If you don't know, how should we know. On this forum we can help you with an Excel solution, when you can indicate the expected results (including the necessary calculations).

+ 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. Replies: 2
    Last Post: 07-29-2021, 01:55 AM
  2. [SOLVED] Headcount
    By sonu1975 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-20-2021, 10:04 AM
  3. How to Get Monthly Headcount
    By abhimanyusodhi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-25-2021, 02:18 PM
  4. Replies: 2
    Last Post: 06-20-2015, 10:40 PM
  5. [SOLVED] Headcount Forecasting
    By Shaun_Chetty in forum Excel General
    Replies: 17
    Last Post: 05-27-2015, 02:45 PM
  6. Replies: 1
    Last Post: 07-17-2013, 11:34 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