time calculation formula

[klutz]

Hi,

I'm trying to figure out how to create a formula to show ads per hour . Table below shows where I would input the amount of ads to be shown and seconds per ad. I have tried different formulas but cant seem to get the right result.

Can anyone advice please? :help

Thanks-




Ads Per Seconds
6 seconds


# of Ads
10


Ads recycle time



Ads per hour

[SamT]

# seconds in Hr = 3600
3600 / (Seconds Per Add + Recycle Time ) = Ads per hour

[klutz]

Thanks Sam but i don't know the recycle time, I mean having a formula to obtain that result.
Still confused.

[SamT]

So am I.

Your saying that you have two parts of a formula that takes three parts to compute.

Without knowing anything else and making these assumptions:

1) The ads run without interruption, meaning that they are the only things being viewed.

2) Each ad runs for 6 seconds and is immediately followed by the next.



10 ads times 6 seconds view time = every ad repeats every 1 minutes.

10 ads per minute = 600 ads per hour.


That is the very best I can do with the tiny information you provided.

[Sock]

# seconds in Hr = 3600
3600 / (Seconds Per Add + Recycle Time ) = Ads per hour


Thanks Sam but i don't know the recycle time, I mean having a formula to obtain that result.
Still confused.

I'm guessing the recycle time is how long until it 'rolls over' to the the start of the ads again (assuming the ads run in a continuous, organized loop). In this case the recycle time would be Seconds per Ad * # of Ads
However, that seems simple. What do you mean by 'recycle time'?

[klutz]

Thanks @SamT and @Sock

Recycle time would be a loop cycle. I thought this would be simple but I guess i was wrong., Perhaps i am not thinking this well enough and I am not articulating my words correctly.

If I have 10 ads running for 6 seconds then the loop time would be 60 seconds meaning that each ad would be seen every minute hence visible 60 times per hour (can't get formula to show this result in excel)

If I have 10 ads running for 10 seconds then the loop time would be 100 seconds (1 minute 40 seconds) meaning that each ad would be seen every 100 seconds hence visible how many : pray2: times per hour.

How do i get a formula in excel that gives the right times per hour.

Confused still:banghead:

[Ringhal]

Taking answers from the previous posts, I put together a small formula (I am hoping is correct).
Ads per hour = 3600 / [Ads per second] * [# of Ads]
60=3600/10*6
36=3600/10*10

[SamT]

"A1" Contains # of Ads
"A2" Contains Display Time of each Ad (In Seconds)
"A3" Shows Loop Time: Formula is "=A1*A2" (loop Time in Seconds)
"A4" Shows # Ads/Hr: Formula is "=3600/A3" (Seconds in Hour / Loop Time in Seconds)

[klutz]

Yep, that there did the job. Cant believe now it was that easy...Thanx for all the contribution.

Saludos form this hot tropical island.

Klutz...