Results 1 to 6 of 6

Thread: Convert Shift into Hourly Format

  1. #1
    Neophyte swatpro's Avatar
    Join Date
    Dec 2019
    Posts
    4
    Articles
    0
    Excel Version
    2016

    Post Convert Shift into Hourly Format



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

    Hi, I need a help to convert the shift wise data into hourly format.

    Please find the attached file and would really appreciate your help.
    Attached Files Attached Files

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,445
    Articles
    0
    Excel Version
    Office 365 Subscription
    There is nothing in the workbook to show what you want. Fill in a few lines of the results table manually to show us.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Neophyte swatpro's Avatar
    Join Date
    Dec 2019
    Posts
    4
    Articles
    0
    Excel Version
    2016
    There is data shift wise i just need to distribute it hourly wise.
    Example 07:00 - 15:00 Shift is having 2 agents so hourly wise 7 am to 3 pm shift will have 2 count on each interval hourly wise but let say there are 4 agents coming 9am so count will be 6 agents at 9 AM.

    It should look something like this, i just cant find a way to apply on all the shift intervals

    Click image for larger version. 

Name:	Capture.JPG 
Views:	10 
Size:	45.6 KB 
ID:	9524
    Last edited by swatpro; 2019-12-29 at 08:57 AM.

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,445
    Articles
    0
    Excel Version
    Office 365 Subscription
    Please mock this up in the actual workbook.
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    Neophyte swatpro's Avatar
    Join Date
    Dec 2019
    Posts
    4
    Articles
    0
    Excel Version
    2016
    Sorry i didn't get you

  6. #6
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,445
    Articles
    0
    Excel Version
    Office 365 Subscription
    Attach the workbook (not a picture) with the results you want mocked up. I am not going to waste time reproducing the data!
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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