Formula to figure out percentage of daily completes


C

colby

I am having trouble figuring out some formulas or ways to calculate
complete percentages for orders. I need to keep track of the number of
orders received daily. I also keep track of the number of completed
orders daily. I need a formula or formulas to keep track of the
percentages of how many orders are completed in 24 hours, 36 hours, 48
hours, and 60 hours. This has to be done daily.

Thanks in advance!
 
Ad

Advertisements

F

Frank Kabel

Hi
can you provide some more information about your data strucutre. e.g.
post some example rows of data (plain text - no attachment please)
 
C

colby

Frank Kabel said:
Hi
can you provide some more information about your data strucutre. e.g.
post some example rows of data (plain text - no attachment please)
Frank,
There are three columns per day of the week. First column is in
date/time structure with the time an order was received. The second
column is the order number. The third column is the completed time.

____________Tuesday 8/24/04________________________|
TimeIn | OrderNumber | TimeOut |
5:15pm 8/24/04 | 123456789 | 3:30pm 8/27/04 |

This is one row of data that would be posted in the spreadsheet. There
would be around 100 entries daily. Each day I would need to know the
percentage of completed orders from the previous days work load that
were completed for each time frame (1 day, 2 days, 3 days, etc).
 
F

Frank Kabel

Hi
just another question :)
Are your date/time values real Excel date/times or are they text
entries?. To test this: what does the formula
=ISNUMBER(A1)
return
 
Ad

Advertisements

C

colby

Frank Kabel said:
Hi
just another question :)
Are your date/time values real Excel date/times or are they text
entries?. To test this: what does the formula
=ISNUMBER(A1)
return
Sorry, the date time format is not what excel formats it as. The cells
will be formatted with actual date format - 8/25/04 11:25 AM

And the formula does return true when I format it as Date.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top