Try

=(E2-C2)/D2


division has higher priority than subtraction so you need to enclose the
subtraction in parenthesis or else you will divide C2 by D2 then do the
subtraction

--


Regards,


Peo Sjoblom


"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