In Progress

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

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

Skills: Excel

See more: lookup business phone number in an excel database for perth wa, excel month budget template business, month business budget template excel, accounting analysis formulas excel sheet, write statistical formulas excel, statistical formulas excel, write statistics formulas excel, use google finance formulas excel, formulas excel stastical, work experience formulas excel, multiple formulas excel, locking formulas excel spreadsheet, locking formulas excel, csv character number excel, match part number excel, lock number excel, inputting formulas excel accounting, making sku number excel, formulas avanzada excel, match number excel, format phone number excel macro, business plan calculations excel, morgage formulas excel, create excel order status file, extract names number excel

About the Employer:
( 1 review ) Austin, United States

Project ID: #12708131

Awarded to:

khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India

$75 USD in 2 days
(207 Reviews)
6.7

29 freelancers are bidding on average $85 for this job

SBITServices

Hello AMIPLOUFF, I have read your project description clearly and what I understood is you want a projects tracking tool. I am expert in excel and i can write some macros to achieve the described functionalities lik More

$35 USD in 1 day
(122 Reviews)
6.5
macroPOL

Hello, I am Excel and VBA expert. Can you provide sample data file? Please note that I have 100% completion rate and 5-star feedback on 50 projects.

$100 USD in 3 days
(57 Reviews)
5.5
sujonmax2

Dear sir, Greeting, Give me 1 chance send good work. Old account has been closed new account start work. I've extensive experience doing the work very [url removed, login to view] work will be absolutely perfect and sound which can ab More

$155 USD in 3 days
(50 Reviews)
5.0
ksriniravi

Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporti More

$30 USD in 2 days
(35 Reviews)
4.9
sonarkaushik

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. More

$99 USD in 2 days
(39 Reviews)
5.5
manwar4393

I can do . if you like I can show you a sample . So please PM me Dear sir I will start now I am web research, data entry and copy typing specialist. My typing speed is 100 word per minute. I am honest and hard w More

$49 USD in 3 days
(44 Reviews)
4.7
The24CarrotsInc

A proposal has not yet been provided

$40 USD in 1 day
(18 Reviews)
4.2
royalcalif

Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Excel . Recipes Mana More

$30 USD in 1 day
(15 Reviews)
4.0
$30 USD in 1 day
(10 Reviews)
3.8
KavTan

I am an Expert in MS Office, can be a useful asset to your kind of project with faster resolution and Complete satisfaction.

$60 USD in 1 day
(23 Reviews)
4.2
gr8tech

I am knowledgeable in Excel and VBA for data analysis and processing. I am capable of assisting you in your requirements. PM for discussions. I have taken note of your needs to work with dates and times to produce the More

$166 USD in 3 days
(18 Reviews)
3.7
jssinfosys

I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. So lets discuss this project in detail and start at More

$45 USD in 2 days
(9 Reviews)
3.8
nimesha1994

Hi, I'm very interested to do your project. I have great knowledge on about your project. I have already read your description and I feel like I would be a great fit for the project. I can start your project right More

$35 USD in 3 days
(5 Reviews)
3.1
hemsingh1

Hi, MS Excel, MS Access & VBA expert with over 8 years of [url removed, login to view] the requirements and ready to start. Can update and work as desired. Thanks

$77 USD in 1 day
(6 Reviews)
2.7
$30 USD in 1 day
(4 Reviews)
2.2
caakshaypatil

** Expert Freelancer with 5 Star Ratings** Hi Qualified Public Accountant with 9 years of experiance in field of Costing, Accounting, Excel etc. Your Project is regarding Costing of Business, as a public accou More

$150 USD in 3 days
(2 Reviews)
1.2
aditilundia7892

Hi I am an Microsoft Excel Expert and can work on data analysis, cleaning and sorting. I can use macros, slicer, power pivots, dynamic drop downs, data validation and customized functions to create the sheets accor More

$155 USD in 3 days
(1 Review)
0.8
harshita0000

A proposal has not yet been provided

$111 USD in 2 days
(0 Reviews)
0.0
mmrajkannan

I am an expert writing excel related programs/formulas and deliver with fine quality. That will make your job easy and you can email me in any point of time to clarify or fine tune. Kindly give an opportunity to ease y More

$222 USD in 5 days
(0 Reviews)
0.0
$45 USD in 2 days
(0 Reviews)
0.0