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
|