| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time In-Time Out/No. of Units
I am doing a time study to see how many units my technicians process. Each
tech has to enter a time they enter the work station, what time they exit the work station and how many units they process while they are in the station. All times are entered into military time. Example: Cell C2: 13:04 (Time In) Cell E2: 14:20 (Time Out) Cell D2: 14 (No. of Units Processed) I want to calculate the process time per unit. I used =E2-C2/D2 and I'm getting 13:24 Does anyone know what is wrong? The time it took was 1 hour and 16 minutes and they processed 14 units. The answer should be around 5 minutes. What am I doing wrong? HELP! Thanks, Karen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting Time to units | Excel Worksheet Functions | |||
| Units Produced / (finish time minus start time)=Units Per Hr | Excel Worksheet Functions | |||
| Adding small units of time and entering them quickly | Excel Discussion (Misc queries) | |||
| Using time formats in minute units | Excel Discussion (Misc queries) | |||
| How do I convert a time units | Excel Discussion (Misc queries) | |||
Threaded Mode
