case per minute calculater

[aivoryuk]

Morning

I'm having a real mental block on how to calclulate in a formula how many cases somebody in a given time
so for example
A1 is how many cases, B1 is how long it took.

A1 has 8 cases
B1 10 mins it took to complete

I know this is very easy but I can't seem to get it right.

 

[VoG]

Like this perhaps?

Excel Workbook
	A	B	C
1	8	00:10:00	0.80
Sheet1

 

[aivoryuk]

Hi is this showing that it has taken 80 secs to work a case?

If so can I get this is minutes I've tried formatting this and it gives me 12 mins?

 

[VoG]

No, that is showing 0.8 cases processed per minute. To calculate time per case

Excel Workbook
	A	B	C
1	8	00:10:00	00:01:15
Sheet3

 

[aivoryuk]

thanks peter that was wgat I was after, can't beleive I couldn't work that one out