G
Guest
Total time was 32 hours 19 minutes 31 seconds. How can I determine the number
of objects per second?
of objects per second?
G
Guest
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).
G
Guest
The number of objects would vary, the formula would use the cell that
contains the number of objects.
contains the number of objects.
G
Guest
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
G
Guest
Sorry an elderly moment you did mean =B2/(A2*24*3600)