Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 23rd 06, 03:15 PM posted to microsoft.public.excel.worksheet.functions
KLD
 
Posts: n/a
Default 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   Report Post  
Old May 23rd 06, 04:07 PM posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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   Report Post  
Old May 23rd 06, 04:09 PM posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default 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   Report Post  
Old May 23rd 06, 04:20 PM posted to microsoft.public.excel.worksheet.functions
KLD
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel should calculate exponentials properly (right to left) expatrie Excel Worksheet Functions 5 April 26th 06 08:34 AM
change date based on time kdp145 Excel Discussion (Misc queries) 7 December 14th 05 03:05 AM
time sheet to calculate 2 different columns John Sullivan Excel Worksheet Functions 1 October 21st 05 06:48 AM
calculate negative or positve difference in time kpmoore Excel Discussion (Misc queries) 2 January 5th 05 02:35 AM
How do I calculate the hours spent on a project by entering a sta. joeh Excel Worksheet Functions 4 November 2nd 04 07:39 PM


All times are GMT +1. The time now is 02:53 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017