Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-07-2010, 03:21 AM
benson.wallace benson.wallace is offline displaying start and finish times as absolute numbers instead of dates Windows XP displaying start and finish times as absolute numbers instead of dates Office 2003
Novice
displaying start and finish times as absolute numbers instead of dates
 
Join Date: Oct 2010
Posts: 5
benson.wallace is on a distinguished road
Default displaying start and finish times as absolute numbers instead of dates

Hi all,

Does anyone know how to customise the Early Start, Early Finish, Late Start and Late Finish fields so that in the columns they display as they number of days/weeks/months since the project began. In other words, suppose I haven't decided on a start date for the project yet, but what I'm interested in seeing is the total number of days/weeks/months needed to complete the project.

If the above is possible, then my follow-on question is - how does one change the network diagram so that it displays the Late Start and Late Finish fields as well?



Thanks,
Benson
Reply With Quote
  #2  
Old 11-07-2010, 10:06 AM
Kimberly Kimberly is offline displaying start and finish times as absolute numbers instead of dates Windows 7 displaying start and finish times as absolute numbers instead of dates Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

I'm not 100% sure this is what you are after, but you can insert a new number column in a table, and then edit the column so it is a formula... [Project Start]-[Early Start], for example. You didn't say what you have tried... I don't know how much experience you have with making formula fields in Project.

Now that you have the calculated field(s), View the Network Diagram.
Format > Boxes
Copy the Template you want to add the field(s) to (a Copy button is provided) to launch the Data Definition dialog box.
Give the template a name
Towards the bottom of the Data Definition dialog boxin the "Choose Cells" section you
can specify which fields you want to add and where to put them
After the Data Definition dialog box is closed, you will need to use the template drop-down to apply the new template.
Reply With Quote
  #3  
Old 12-05-2010, 07:22 AM
benson.wallace benson.wallace is offline displaying start and finish times as absolute numbers instead of dates Windows XP displaying start and finish times as absolute numbers instead of dates Office 2003
Novice
displaying start and finish times as absolute numbers instead of dates
 
Join Date: Oct 2010
Posts: 5
benson.wallace is on a distinguished road
Default

Hi Kimberly,

Finally got around to looking at this one.

I actually found a more detailed "how-to" at this link:

http://forums.techarena.in/microsoft...ct/1342084.htm

If you read Steve House's suggestions for formulae, and then use JulieS and m3lyssa's corrections, it all works out. m3lyssa multiplied by -1, but you can just swap the order of the fields inside the brackets and the result is the same.

Once the ES, EF, LS and LF fields were defined, it was just a question of tweaking the box template formatting until it looked the way I wanted it to.

Cheers,
Benson
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
displaying start and finish times as absolute numbers instead of dates Calculated dates. Ziggy-R Word 10 09-28-2010 01:42 AM
displaying start and finish times as absolute numbers instead of dates How To Get Image to be absolute center of slide mjg060468 PowerPoint 3 08-09-2010 02:07 PM
displaying start and finish times as absolute numbers instead of dates Setting Drop Dead Start Dates greenboard Project 2 06-14-2010 08:12 AM
MS Project able to import actual start and or actual finish date from Excel? mhacker Project 0 04-26-2010 11:29 AM
Adding dates mkkram Word 0 11-27-2006 09:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:17 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft