Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determining work hours between dates / hours | Excel Worksheet Functions | |||
Spread Sheet Employee Hours Issue | Excel Worksheet Functions | |||
Is there a way to change all dates in a spread sheet | Excel Discussion (Misc queries) | |||
adding information to cells uniformally | Excel Discussion (Misc queries) | |||
how to chart data spread over 24 hours a day and 7 days a week? | Charts and Charting in Excel |