| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Starting payment when increase rate is known & total payment is kn | Excel Worksheet Functions | |||
| Number in cell increase with increase in font size. | Excel Discussion (Misc queries) | |||
| how do I increase the number of cells I want to total | Excel Discussion (Misc queries) | |||
| Old Lotus Sub Total & Grand Total formula | Excel Discussion (Misc queries) | |||
| XL formula - total of row = total of column | Excel Worksheet Functions | |||
Linear Mode
