# time elapsed formula

1. ## 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. ## Re: time elapsed formula

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
>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. ## 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:

>
> 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
> >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. ## 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:
>
>>
>> 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
>> >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 .

>>
>>
>>

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

#### 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