Formula to increase value according to total
 

anybody know if you can do a formula that will increase by 1 every 2 hours??

Column A (Open Time) = 13:00 (1 PM)
Column B (Close Time) = 22:00 (9 PM)
Column C (Total) = 9:00 (9 Hours)
Column D (Opportunities) = 4 (could've contacted cst 4 times in 9 hours, 1
opportunity every 2 hours)

so, I need to add 1 per every 2 hours a file was opened. In this case Column
D would give me a value of "4" .

Thanks,
Mayte

Formula to increase value according to total
 

Try this:

=INT(C1*24/2)

--
Biff
Microsoft Excel MVP


"Mayte" wrote in message
...
anybody know if you can do a formula that will increase by 1 every 2
hours??

Column A (Open Time) = 13:00 (1 PM)
Column B (Close Time) = 22:00 (9 PM)
Column C (Total) = 9:00 (9 Hours)
Column D (Opportunities) = 4 (could've contacted cst 4 times in 9 hours, 1
opportunity every 2 hours)

so, I need to add 1 per every 2 hours a file was opened. In this case
Column
D would give me a value of "4" .

Thanks,
Mayte

Formula to increase value according to total
 

ACE !! ... thanks a lot !!

Cheers,
Mayte

"T. Valko" wrote:

Try this:

=INT(C1*24/2)

--
Biff
Microsoft Excel MVP


"Mayte" wrote in message
...
anybody know if you can do a formula that will increase by 1 every 2
hours??

Column A (Open Time) = 13:00 (1 PM)
Column B (Close Time) = 22:00 (9 PM)
Column C (Total) = 9:00 (9 Hours)
Column D (Opportunities) = 4 (could've contacted cst 4 times in 9 hours, 1
opportunity every 2 hours)

so, I need to add 1 per every 2 hours a file was opened. In this case
Column
D would give me a value of "4" .

Thanks,
Mayte

Formula to increase value according to total
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Mayte" wrote in message
...
ACE !! ... thanks a lot !!

Cheers,
Mayte

"T. Valko" wrote:

Try this:

=INT(C1*24/2)

--
Biff
Microsoft Excel MVP


"Mayte" wrote in message
...
anybody know if you can do a formula that will increase by 1 every 2
hours??

Column A (Open Time) = 13:00 (1 PM)
Column B (Close Time) = 22:00 (9 PM)
Column C (Total) = 9:00 (9 Hours)
Column D (Opportunities) = 4 (could've contacted cst 4 times in 9
hours, 1
opportunity every 2 hours)

so, I need to add 1 per every 2 hours a file was opened. In this case
Column
D would give me a value of "4" .

Thanks,
Mayte