Archive of Mr Excel Message Board


Back to Pivot Tables in Excel archive index
Back to archive home

Excel question

Posted by Joe on January 04, 2001 10:27 PM
I need to compute the number of work hours available between two dates. That is the easy part ... using the existing excel functions, but I need to use these numbers automatically in a staffing profile.

For example: I can compute the number of hours available between 15 feb 2001 and 22 aug 2001 fairly simply, but I then need to split out the hours in feb, the hours in march, the hours in april, ... etc. etc. and put them into an array that I will then chart to show a staffing profile. I need to do this for a series of dozens of tasks that spread across the next 7 or 8 years, some only a couple of months long, others a year or more.

Anyone have any idea how I can get this to work?

Joe


Re: Excel question

Posted by Dave on January 05, 2001 1:00 AM


Hi Joe

If your hours and dates are set up in a list style you could use either a Pivot Table or the DSUM. Personally I would go with a Pivot Table very handy little feature.


Dave
OzGrid Business Applications


Re: Excel question

Posted by Joe on January 07, 2001 9:44 AM
Thanks. I will give it a try.

Joe


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.