Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating Objects Per Second
Total time was 32 hours 19 minutes 31 seconds. How can I determine the number
of objects per second? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set objects not to scroll | Excel Discussion (Misc queries) | |||
how can I hyperlink from objects on the web? | Excel Discussion (Misc queries) | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Calculating the Area of objects in Feet and Inches | Excel Discussion (Misc queries) | |||
VBA Objects | Excel Discussion (Misc queries) |