+ Reply to Thread
Results 1 to 4 of 4

time elapsed formula

  1. #1
    sue
    Guest

    time elapsed formula

    I need to calculate two formulas.

    1. Need to create a formula for % time elapsed (based on 365 days)
    2. Need to create a formula for % to Forecast vs time elapsed .

  2. #2
    Fred Smith
    Guest

    Re: time elapsed formula

    More information would be useful.

    For 1, are you saying you have a start date, an end date, and a current date,
    and you want to know what % of the period has elapsed from start to current? If
    so, try:

    =(current - start) / (end - start), format as percent.

    For 2, you might be able to compare this calculated % with the forecast %. If
    that's not what you are looking for, post back with more details.

    --
    Regards,
    Fred


    "sue" <sue@discussions.microsoft.com> wrote in message
    news:8EF980A1-3856-4362-AAD4-7BBD8CDB58E5@microsoft.com...
    >I need to calculate two formulas.
    >
    > 1. Need to create a formula for % time elapsed (based on 365 days)
    > 2. Need to create a formula for % to Forecast vs time elapsed .




  3. #3
    sue
    Guest

    Re: time elapsed formula

    Let's say the spread sheet measures sales volume for 365 days (06 calendar
    year). So, some of the columns on the page going across are:

    $ sales month to date; $ sales ytd; Forecasted volume; % to forecast ytd.

    I think the formula is year to date $ sales / total forecast = % to yearly
    forecast..

    but we will be comparing that to total time elapsed for the year.. I don't
    know how to do do it. This should be a running formula that "ticks" away
    the year in %.. so we know how much time we have left to make the number vs %
    to actual $'s achieved to date. Make sense?

    "Fred Smith" wrote:

    > More information would be useful.
    >
    > For 1, are you saying you have a start date, an end date, and a current date,
    > and you want to know what % of the period has elapsed from start to current? If
    > so, try:
    >
    > =(current - start) / (end - start), format as percent.
    >
    > For 2, you might be able to compare this calculated % with the forecast %. If
    > that's not what you are looking for, post back with more details.
    >
    > --
    > Regards,
    > Fred
    >
    >
    > "sue" <sue@discussions.microsoft.com> wrote in message
    > news:8EF980A1-3856-4362-AAD4-7BBD8CDB58E5@microsoft.com...
    > >I need to calculate two formulas.
    > >
    > > 1. Need to create a formula for % time elapsed (based on 365 days)
    > > 2. Need to create a formula for % to Forecast vs time elapsed .

    >
    >
    >


  4. #4
    Fred Smith
    Guest

    Re: time elapsed formula

    Make sense? No.

    Try posting a specific example. I'm sure that will help us figure out what
    you're trying to do.

    --
    Regards,
    Fred


    "sue" <sue@discussions.microsoft.com> wrote in message
    news:D3EC7EE4-E6D5-4943-B2A2-5021DD9A0235@microsoft.com...
    > Let's say the spread sheet measures sales volume for 365 days (06 calendar
    > year). So, some of the columns on the page going across are:
    >
    > $ sales month to date; $ sales ytd; Forecasted volume; % to forecast ytd.
    >
    > I think the formula is year to date $ sales / total forecast = % to yearly
    > forecast..
    >
    > but we will be comparing that to total time elapsed for the year.. I don't
    > know how to do do it. This should be a running formula that "ticks" away
    > the year in %.. so we know how much time we have left to make the number vs %
    > to actual $'s achieved to date. Make sense?
    >
    > "Fred Smith" wrote:
    >
    >> More information would be useful.
    >>
    >> For 1, are you saying you have a start date, an end date, and a current date,
    >> and you want to know what % of the period has elapsed from start to current?
    >> If
    >> so, try:
    >>
    >> =(current - start) / (end - start), format as percent.
    >>
    >> For 2, you might be able to compare this calculated % with the forecast %. If
    >> that's not what you are looking for, post back with more details.
    >>
    >> --
    >> Regards,
    >> Fred
    >>
    >>
    >> "sue" <sue@discussions.microsoft.com> wrote in message
    >> news:8EF980A1-3856-4362-AAD4-7BBD8CDB58E5@microsoft.com...
    >> >I need to calculate two formulas.
    >> >
    >> > 1. Need to create a formula for % time elapsed (based on 365 days)
    >> > 2. Need to create a formula for % to Forecast vs time elapsed .

    >>
    >>
    >>




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1