Time In-Time Out/No. of Units

[Karen]

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

 

[Fred Smith]

You need parentheses around your calculation, as in:

=(e2-c2)/d2

Regards,
Fred.

 

[Peo Sjoblom]

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

 

[Ashish Mathur]

Hi,

If you want the answer in decimal points, use =(E2-C2)*24*60/D2. The answer
will be 5.428

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Karen]

Thank you so much for your help.
Have a great weekend
Karen

 

[Karen]

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

 

[Karen]

Thank you for your help.
My answer is 10:17.
I'm not sure what I did wrong.I copied the formula exactly.
Karen

 

[bnbspop]

Change the hh:mm format to [hh]:mm and use 24:00 for midnight and
25:00 for 1am and so on.

 

[Karen]

Thank you for your suggestion. Although, my boss wants it in military time.
Therefore, I cannot use 25:00. Any other suggestions?
Thanks, Karen

 

[Karen]

Thank you
I used =MOD(E2-C2,1)/D12

My raw data is:
Time In: 22:20
Time Out: 00:35
Units Processed: 36

My answer is 00:02
Shouldn't it be over 3 minutes?
That's 2 hours and 15 minutes (135 minutes)
135/36 = 3.75

Did I something wrong?
Thanks, Karen

 

[Peo Sjoblom]

When I do that using your data I get 00:03:45 which is the same as 3.75
decimal minutes, somewhere your raw data is incorrect. Do you have 36 in
D12? You would have to divide by 67 units to get that result. The formula
definitely works

--


Regards,


Peo Sjoblom