| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average Time for Specific Item
Thanks in advance for any help!
I am trying to calculate the average time it takes to accomplish a specific task amongst many tasks during an 8 hour weekday, excluding holidays. Work day is from 8 AM to 4 PM. Model Date Received Date finished Ford 10/17/07 8:30 AM 10/18/07 12:00 PM Chevy 10/17/07 8:00 AM 10/17/07 12:00 PM Ford 10/17/07 8:00 AM 10/17/07 12:00 PM Chevy 10/17/07 8:40 AM 10/17/07 12:00 PM Ford 10/18/07 9:41 AM 10/19/07 12:00 PM Dodge 10/18/07 9:15 AM 10/18/07 12:00 PM What formula would allow me to find out the average time it takes to process a Ford? Thanks again! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selectin an specific item on the spreadsheet. | Excel Discussion (Misc queries) | |||
| Finding a specific item between two sheets. | Excel Discussion (Misc queries) | |||
| INVENTORY CONTROL BY SPECIFIC ITEM | Excel Discussion (Misc queries) | |||
| Count Specific Item in Specific Row | Excel Discussion (Misc queries) | |||
| how to count specific item??? | Excel Discussion (Misc queries) | |||
Threaded Mode
