Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I calculate amount of time left based on amount spent?
I need a way to calculate time left based on how much has been spent to date.
I have an original amount, and a period that the money has been set up to be spent in, so I need a way to calculate how long we have to spend it based on what was spent previously. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I calculate amount of time left based on amount spent?
An example might help.
-- HTH Bob Phillips (remove xxx from email address if mailing direct) "KLD" wrote in message ... I need a way to calculate time left based on how much has been spent to date. I have an original amount, and a period that the money has been set up to be spent in, so I need a way to calculate how long we have to spend it based on what was spent previously. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I calculate amount of time left based on amount spent?
Assuming a linear rate of spending, you could obtain the percentage
spent so far (i.e. money spent divided by total amount), and then multiply this by the overall period in which you have to spend the money. However, this makes a lot of assumptions. If you add the start date to the overall period, then you will have the end date, and if you subtract the function TODAY() from this it will give you the number of days remaining (or however you format it). Hope this helps. Pete |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I calculate amount of time left based on amount spent?
Okay maybe this will help:
I have $500,000. I have six months time in which this money must be spent, or lost. I got the funds 4/1. In April, I spent $120,000. I need the formula to tell me how long I would have if I kept spending $120,000 a month. I'll change the cell refrence on a monthly basis, that way if I spend $135,000 in May, I will get a new calc. since obviously the funds would run out more quickly. Hope that helps! "Bob Phillips" wrote: An example might help. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "KLD" wrote in message ... I need a way to calculate time left based on how much has been spent to date. I have an original amount, and a period that the money has been set up to be spent in, so I need a way to calculate how long we have to spend it based on what was spent previously. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should calculate exponentials properly (right to left) | Excel Worksheet Functions | |||
change date based on time | Excel Discussion (Misc queries) | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
How do I calculate the hours spent on a project by entering a sta. | Excel Worksheet Functions |