Hours spread uniformally between two dates

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

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
 
Steve said:
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.
Click to expand...

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
 
Thanks for help Bill ....

Bill Manville said:
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
Click to expand...
 
Back
Top