Completed

excel formulas (number of business minutes) and charting (month over month)

This project was successfully completed by khushh07 for $75 USD in 2 days.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Completed In
2 days
Total Bids
32
Project Description

I have a spreadsheet that I need formulas. Here's the data I have:

day/hour/Minute project was submitted

day/hour/Minute project was suspended

day/hour/Minute project was resubmitted

day/hour/Minute project was approved

day/hour/Minute project was resubmitted for re-approval

day/hour/Minute project was re-approved

current status (processing, closed won, closed lost)

complications:

1. some projects were submitted, suspended,resubmitted or approved after business hours - should be rounded up to the next business minute

2. some projects were suspended and resubmitted - this is "suspense time". The suspense time should be removed from the project time

Need to determine

1. how many business hours (including fraction hours) each project took. (from submitted through approved, minus suspense time)

2. percent of projects suspended - month over month

3. percent of projects submitted to approved with no suspense - month over month

4. average business hours each project took - month over month

5. number of projects resubmitted for re-approval - month over month

6. average amount of business hours of the suspense time - month over month

7. percent of projects which were approved and closed lost - month over month

8. percent of projects approved and closed won - month over month

Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online