Formula to figure out percentage of daily completes

[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!

 

[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)

 

[colby]

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).

 

[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

 

[colby]

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.