J
JM
Total time was 32 hours 19 minutes 31 seconds. How can I determine the number
of objects per second?
of objects per second?
M
Mike H
Well that would depend on how many 'Objects' appeared, disappeared or were
otherwise to be accounted for within that time period!!
otherwise to be accounted for within that time period!!
D
David Biddulph
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).
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).
J
JM
The number of objects would vary, the formula would use the cell that
contains the number of objects.
contains the number of objects.
M
Mike H
I never thought of it like that
could you have meant =(A2*24*3600)/B2
Mike
could you have meant =(A2*24*3600)/B2
Mike
M
Mike H
Sorry an elderly moment you did mean =B2/(A2*24*3600)