View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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?