Homework Helper

Not Rated (0)

$17/per page/

About Homework Helper

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Applied Sciences See all
Accounting,Applied Sciences,Art & Design,Chemistry,Economics,Essay writing Hide all
Teaching Since: Apr 2017
Last Sign in: 419 Weeks Ago, 4 Days Ago
Questions Answered: 3232
Tutorials Posted: 3232

Education

  • MBA,MCS,M.phil
    Devry University
    Jan-2008 - Jan-2011

  • MBA,MCS,M.Phil
    Devry University
    Feb-2000 - Jan-2004

Experience

  • Regional Manager
    Abercrombie & Fitch.
    Mar-2005 - Nov-2010

  • Regional Manager
    Abercrombie & Fitch.
    Jan-2005 - Jan-2008

Category > Business & Finance Posted 11 Sep 2017 My Price 12.00

Excel Cycle time question:

Excel Cycle time question:

 

You will need to perform a data analysis on our Service Request (SR) cycle time:

 

Specifically, What is the end-to-end cycle time - (Formula: Column D - Column C)

 

There are 4 different teams - (Diamond, Gold, Silver, and TSS-A) ....All other enteries are typos/bad data.

 

Perform a data analysis to highlight which teams are the best and which are the worst. Obviously, you will need to clean the data first to make sure you have no outliers, negative values, blank rows etc.

 

** Cycle time only includes workdays (exclude weekends) and only includes 9am - 5pm working hours. The rest of the day can be ignored from the cycle time - you can search the web for any appropriate formulas that will help you.

 

The data file is attached SR Cycle time_Modified.xls

_______

 

I've attached the Excel document I've been working on so far, but my question is, how can filter by a range of hours (9am-5pm) when it's over multiple days? 

 

I know how to do it if it was only one day, but I'm stuck on how to do it over multiple days. I could manually break it down by each day and only count the hours on that day and then add it up, but I was wondering if there's a quicker formula that could count the cycle time for me based on what's already on my spreadsheet. 

 

Also, how to filter out Saturdays and Sundays? By what I've done I can filter out if it started or ended on a Sat. or Sunday, but I also want to filter out those days in between. For example, if the cycle was from Friday, Sept. 8 to Monday Sept. 11., how do I filter out the Sat. and Sunday in between the start and end date?

Attachments:

Answers

Homework Helper
Not Rated (0)
Status NEW Posted 11 Sep 2017 06:09 PM My Price 12.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k Y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)