Calculating Objects Per Second
 

Total time was 32 hours 19 minutes 31 seconds. How can I determine the number
of objects per second?

Calculating Objects Per Second
 

Well that would depend on how many 'Objects' appeared, disappeared or were
otherwise to be accounted for within that time period!!

"JM" wrote:

Total time was 32 hours 19 minutes 31 seconds. How can I determine the number
of objects per second?

Calculating Objects Per Second
 

If the time 32:19:31 is in A2, and the number of objects in B2, then the
number of objects per second is
=B2/(A2*24*3600)
Remember to format the answer as General or Number (as Excel will probably
try to make it Time).
--
David Biddulph

"JM" wrote in message
...
Total time was 32 hours 19 minutes 31 seconds. How can I determine the
number
of objects per second?

Calculating Objects Per Second
 

The number of objects would vary, the formula would use the cell that
contains the number of objects.

"Mike H" wrote:

Well that would depend on how many 'Objects' appeared, disappeared or were
otherwise to be accounted for within that time period!!

"JM" wrote:

Total time was 32 hours 19 minutes 31 seconds. How can I determine the number
of objects per second?

Calculating Objects Per Second
 

I never thought of it like that:)

could you have meant =(A2*24*3600)/B2

Mike

"David Biddulph" wrote:

If the time 32:19:31 is in A2, and the number of objects in B2, then the
number of objects per second is
=B2/(A2*24*3600)
Remember to format the answer as General or Number (as Excel will probably
try to make it Time).
--
David Biddulph

"JM" wrote in message
...
Total time was 32 hours 19 minutes 31 seconds. How can I determine the
number
of objects per second?

Calculating Objects Per Second
 

Sorry an elderly moment you did mean =B2/(A2*24*3600)


"David Biddulph" wrote:

If the time 32:19:31 is in A2, and the number of objects in B2, then the
number of objects per second is
=B2/(A2*24*3600)
Remember to format the answer as General or Number (as Excel will probably
try to make it Time).
--
David Biddulph

"JM" wrote in message
...
Total time was 32 hours 19 minutes 31 seconds. How can I determine the
number
of objects per second?