Hours spread uniformally between two dates
 

Hi,

Is there any functionality within excel where an amount of hours (col a )
can be spread uniformally between two dates (col b and c) with the results
tabled so i am able to create a load or capacity graph.

Thanks in advance for any assistance in any form.

Steve

Hours spread uniformally between two dates
 

Steve wrote:
Is there any functionality within excel where an amount of hours (col a )
can be spread uniformally between two dates (col b and c) with the results
tabled so i am able to create a load or capacity graph.


You might have columns to the right from D to BZ, one per date, and you want
to fill in the number of hours for the job on this row on the date for this
column (assumed in row 1).

A formula like this (in D2 and copied to the remaining cells) should do it

=A2/(COUNTIF($D$1:$BZ$1,"="&B2)-COUNTIF($D$1:$BZ$1,""&C2))


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup

Hours spread uniformally between two dates
 

Thanks for help Bill ....

"Bill Manville" wrote in message
...
Steve wrote:
Is there any functionality within excel where an amount of hours (col
a )
can be spread uniformally between two dates (col b and c) with the
results
tabled so i am able to create a load or capacity graph.


You might have columns to the right from D to BZ, one per date, and you
want
to fill in the number of hours for the job on this row on the date for
this
column (assumed in row 1).

A formula like this (in D2 and copied to the remaining cells) should do it

=A2/(COUNTIF($D$1:$BZ$1,"="&B2)-COUNTIF($D$1:$BZ$1,""&C2))


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup