Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Creating a Project Schedule, displaying the hours per day.

I am wondering if it's possible to create a spreadsheet with a start date, #
of hours and dates along the top... When the hours are updated I'd like the #
of hours per day to be worked on the project timeline.

Hopefully that makes some sense.

--

Paul Monsef
Monsef Consulting and Design

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default Creating a Project Schedule, displaying the hours per day.

http://office.microsoft.com/en-us/te...CT101436151033
--
Gary''s Student - gsnu200769


"Paul Monsef" wrote:

I am wondering if it's possible to create a spreadsheet with a start date, #
of hours and dates along the top... When the hours are updated I'd like the #
of hours per day to be worked on the project timeline.

Hopefully that makes some sense.

--

Paul Monsef
Monsef Consulting and Design

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Creating a Project Schedule, displaying the hours per day.

Thanks for the reply.

I was looking for like type of format:
http://www.monsefdesign.com/ProjectS...s-Timeline.mht

Where, the individual days are filled in via conditional formatting. I guess
it's more of a 'timline' approach than the example you sent. I have to fill
in the hours manually, I was hoping for a way to have the total hours
distributed across the 'blue cells' automatically.

Thanks again for any aid.

--

Paul Monsef
Monsef Consulting and Design



"Gary''s Student" wrote:

http://office.microsoft.com/en-us/te...CT101436151033
--
Gary''s Student - gsnu200769


"Paul Monsef" wrote:

I am wondering if it's possible to create a spreadsheet with a start date, #
of hours and dates along the top... When the hours are updated I'd like the #
of hours per day to be worked on the project timeline.

Hopefully that makes some sense.

--

Paul Monsef
Monsef Consulting and Design

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
template for construction project schedule GoldenMTB Excel Discussion (Misc queries) 0 October 9th 09 07:10 PM
how do u set up project schedule in excel Me_moi_i Excel Discussion (Misc queries) 2 November 1st 08 02:22 PM
Creating a formula to display # of work hours spent on a project KerryM1212 Excel Discussion (Misc queries) 1 August 3rd 07 06:22 PM
Loan Amortization Schedule project oscramx1l3sc4 Excel Discussion (Misc queries) 2 July 24th 07 06:02 AM
Project Management Schedule JPriest Excel Worksheet Functions 1 October 29th 05 04:41 AM


All times are GMT +1. The time now is 08:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"