Thank you for your help.
What if I have a time like so:
Time In: 22:20
Time Out: 00:35
Units Processed: 36
It's not calculating.
HELP!
Thanks, Karen

"Fred Smith" wrote:

You need parentheses around your calculation, as in:

=(e2-c2)/d2

Regards,
Fred.

"Karen" wrote in message
...
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


.