How do I read the Start and End Time of a Day

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Project
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Multiproject Merging I have in MS Project 2003 standard a multiproject from 15 input single projects. Now I need to have only one project with the same contetns. How can I do it not so laborious ? Thanks Ivan Samel Tag: How do I read the Start and End Time of a Day Tag: 110508
  - 2
    - HOWTO have tasks without wbs code Hi all, I have a schedule where in the top lines I keep the contract award and program milestones with deadlines dates. These tasks are linked (with SS relationships) to the corresponding review activity in the network schedule. This way I can see if I have a problem in meeting customer predefined dates for the milestones without setting constraint dates (that could spoil the Critical Path). My question is how can I exclude these tasks from having a WBS code? I saw a schedule like this in the afmc pamphlet 63-5. Thanks you all, Andr=E9 Tag: How do I read the Start and End Time of a Day Tag: 110507
  - 3
    - Tasks keep moving Hi, When I have a few tasks all linked. If I change the start time or duration of one of the tasks all the tasks before it will change and the ones below wont. What I am trying to do is move the task in the middle and then have all the ones below move forward and not the ones before. I hope it is clear, if not please ask. Thanks for your help in advance. Tag: How do I read the Start and End Time of a Day Tag: 110500
  - 4
    - How do I Lock Resource Name Field I would like limit use of resources to only those that are listed on the Resource Sheet. Currently, names typed incorrectly whilst in the Gantt Chart view are saved as a new resource. How can I prevent this? Tag: How do I read the Start and End Time of a Day Tag: 110493
  - 5
    - Setting default task types Is there a way to set the task type (fixed work, units or duration) to a value for all tasks entered in my plan, e.g., I'd like to set all tasks to fixed work. I'm buildling a template for a project team and I'd like the team's plans to default to fixed work. Paul Peterson Velox Consulting, LLC Tag: How do I read the Start and End Time of a Day Tag: 110491
  - 6
    - How do I mark a task as highlighted or critical? I realize I cannot change the font for the text in the Calendar view so now I thought I woud attack the problem by marking the tasks as marked/highlighted/critical/noncritical, but can't find how to do that either. Tag: How do I read the Start and End Time of a Day Tag: 110472
  - 7
    - Linking to Excel In general, can you link Project to Excel data such as dates and descriptions? To what extent can you link data between the two programs. Any help would be appreciated, JAD Tag: How do I read the Start and End Time of a Day Tag: 110469
  - 8
    - project server 2003 Is there an evalutation edition of MS Project Server 2003 anywhere. I've searched all over the microsoft.com and couldn't find it. Does it not exist? TIA Tag: How do I read the Start and End Time of a Day Tag: 110468
  - 9
    - Start-to-Finish Example Could someone give me a few examples of the use of a Start-to-Finish dependency? Also, how should a successor behave if you increase the successor's duration? I'm curious to see before and after shots. Tag: How do I read the Start and End Time of a Day Tag: 110465
  - 10
    - Text 1 not visible in other views Hello all, I have what I hope is a simple question. In the Task Sheet view I have created a column to track sales order numbers of new jobs, using text 1. When I switch to the resourse useage sheet view and attempt to insert the Text 1 column, no data appears in the column. I assumed that Text 1 was always the same value regardless of the sheet it is being viewed in. Am I in left field here or am I messing up something very simple which will make me want to beat my head against the desk? Thanks, Roger Tag: How do I read the Start and End Time of a Day Tag: 110463
  - 11
    - Word document opens as "reading layout" and comes up as read only Hi, I have 2 problems I am hoping to get resolved: 1. I am trying to fighure out how to change the default layout of word documents that open with the project server 2003 document library for any project. I have gone to the "Customize Shared Documents", and attempted to edit the template. It saves like the system took it, but when I open another document, it shows up with the reading layout again. 2. Everytime I save a document and open it up again, it comes up as read only. Yet I can still modify it. I did some searching and found some people suggested that the file may be checked out by another person. So I created a new document and was confronted with same problem again. I am the administrator and have full access. I made sure the documents were not read only, and had no restrictions before I uploaded them. Any help would be appreciated... Thanks Tag: How do I read the Start and End Time of a Day Tag: 110457
  - 12
    - Can Project 2000 be upgraded to Project 2003? I would like to upgrade Project 2000 to Project 2003. Can I skip XP? Can I do it with an upgrade? My vendor is telling me I have to buy a full license of Project 2003 -- not an upgrade. Thanks. Tag: How do I read the Start and End Time of a Day Tag: 110440
  - 13
    - Overallocation on 8 hour days I've been having a problem where certain resource appear to be overallocated on days for which they are scheduled for the full amount of their working hours. I've checked their work schedule setup from the resources screen and even though they have 8 working hours in a day if they're assigned more than, let's just say 6 hours, they appear as overallocated on the Resource Graph. The problem "appears" sporadically so I'm not sure what could be causing it. What should I be checking to fix this problem? Tag: How do I read the Start and End Time of a Day Tag: 110438
  - 14
    - phone log? I need to keep an on-going phone log of the follow-up conversations with clients. what is recommended: database or spreadsheet. Any suggestions how to set it up? What fields or column headings? Tag: How do I read the Start and End Time of a Day Tag: 110437
  - 15
    - Export to Excel I am new to MS Project. I have set up a project that has a number or summary tasks each with a set of sub-tasks. Some of the sub-tasks also have sub tasks. What I want to be able to do is export tasks to Excel creating a sheet that enables me to easily sum the number of 'work units' involved in the project ie Main 1 5 days Sub 1 1 day Sub 2 4 days Sub 2 Sub 1 1 day Sub 2 Sub 2 3 days In Project it is obvious that the duration for Main 1 is the sum of the times for Sub 1 & Sub 2 (which in turn is the sum of Sub 2 Sub 1 & Sub 2 Sub 2). However, when this gets exported to Excel I get the following WBS Name Duration 1 Main 1 5 days 1.1 Sub 1 1 day 1.2 Sub 2 4 days 1.2.1 Sub 2 Sub 1 1 day 1.2.2 Sub 2 Sub 2 3 days This format makes it 'impossible' to derive the total amount of work for project, Is there any way to isolate the figures that are actually for work and not for summaries while still keeping the summaries in the sheet for clarity? Tag: How do I read the Start and End Time of a Day Tag: 110435
  - 16
    - Updating Status/Splitting Tasks Once I update the status of my project I need to upload it to Deltek Cobra (EVM reporting tool) to get the Earned Value metrics. Cobra requires that all tasks that are scheduled around the status date be completed before the status date - so they either have to be 100% complete or the task has to be split so that one part ends before the status date and the remaining part starts after the status date. What is the best way to do that? Thanks for your help, nan Tag: How do I read the Start and End Time of a Day Tag: 110434
  - 17
    - I want to launch MS Project to open a file, run a macro then close I need to automate the collection of metric data from multiple MS Project files. For each MPP file, I want to launch MS Project, run a macro to save my data, then close. So far, I have been able to call up Project with a command like the following "C:\Program Files\Microsoft Office2003\OFFICE11\WINPROJ.EXE" -"E:\Documents\Metrics\MyProject.mpp" I have no idea how to pass in a parameter to get the macro run. Can this be done? Also, I would prefer to run MS Project silently, so that the person running the batch file does not see the GUI zoom into view repeatedly. Is this possible? -- Jane Kirby Tag: How do I read the Start and End Time of a Day Tag: 110432
  - 18
    - land development project template Hi, I'm using MS Project Professional and would like to get hold of a land development project template Tag: How do I read the Start and End Time of a Day Tag: 110426
  - 19
    - what is leveled based on day by day setting Hi all, When ever i try to publish project from project pro 2003, i encouter an error in the project pro spooler: The windows user account or user name for the affected user account conflicts with an existing account on the server. Then when i go to resource sheet under view, there is another error saying:The leveled should be based on day by day setting. Please help me. Thanks all, CHeers! Tag: How do I read the Start and End Time of a Day Tag: 110425
  - 20
    - Project 2003. Adding calculations into columns I wish to add an additional column for hours. I wish it to claculate like the Works column but to operate seperatley Tag: How do I read the Start and End Time of a Day Tag: 110418
  - 21
    - how do I merge 2 project plans in MS project plan 2003 Hi I have 3 project plans for same project & different activities. I need to merge into one MPP. Please advise. regards vijay Tag: How do I read the Start and End Time of a Day Tag: 110416
  - 22
    - Back Space and deleting not working properly in word When I highlight some text and hit the backspace key in Microsoft Office Word 2003 rather then deleting the selected text the courser just moves to the space immediately before the selected test and the text becomes unselected. Also when I highlight text and then begin typing, rather then replacing the highlighted text with what I'm typing it does the same thing as above then adds my new typings before the previously selected text. Any help on how to get this resolved is appreciated. BTW i am running XP on a Toshiba Satellite A85 laptop if that helps. Tag: How do I read the Start and End Time of a Day Tag: 110413
  - 23
    - Changing start date and creating formula for finish date In Project 2003 Standard, is there a way to change the start date for a group of existing unfinished tasks (that aren't linked or related in any way) to today's date in one fell swoop? Also, is there a formula that can be used to make the finish dates for existing and new tasks to be Start date + 12 months? I think it is DateAdd, but I cannot make it work using Tools/Customize/Fields. What settings should be used there? -- Tag: How do I read the Start and End Time of a Day Tag: 110412
  - 24
    - Changing resource calendar with a 24 hour project calendar We have a project that is set up with a 24 hour calendar and resources that are allocated either to a 24 hour or a 12 hour calendar. If we change a task with a 24 hour resource calendar to a 12 hour resource calendar, the task still showed as the resource working through the night as if they were on the 24 hr calendar. The task is a fixed unit task. By doing this, our critical path also changes - any ideas why? Thanks Tag: How do I read the Start and End Time of a Day Tag: 110410
  - 25
    - Problems with copy picture I can not use the copy picture function or the copy picture wizard. If using the wizard it stops on step 4 of 4. If using copy picture it says something about a graphic filter. to check path, memory & close programs. I have tried putting a new path no help and I have 80% free disk space and 2 gig of RAm with nothing else open. Any help, it did work previously.\ Thanks Kevin Tag: How do I read the Start and End Time of a Day Tag: 110405
- Next
  - 1
    - installing microsoft offfice on another computern When I received my microsoft office 2003 I did not receive a special code to enter when installing program. I would like to find out how I can reteive this information so I can install my program. Tag: How do I read the Start and End Time of a Day Tag: 110397
  - 2
    - format proposal im a landscaper ill like to no how to put together a formal proposal includes martials labor phase .project time Tag: How do I read the Start and End Time of a Day Tag: 110394
  - 3
    - Microsoft Project 2007 Beta Collaboration Setup How do i setup project collaboration and a server account? Tag: How do I read the Start and End Time of a Day Tag: 110393
  - 4
    - Classes of days of week issue We are creating a monstor of a plan that has multiple departments and ALL company projects and activities -- we are using the durations only NOT resourcing at this time. However, I am curious as to how to show some training activities at the company. For example, if we have 7 classes that are over a 7 week period and occupy one day a week. I have it setup under the umbrella task of training, then seven tasks that say training1,2,3,4,etc. and the duration is one week, BUT it is really only one day, but offered weekly. How do I show the umbrella as seven week duration but each task has a one day duration with 4 day "lag"? Help.. :) Tag: How do I read the Start and End Time of a Day Tag: 110384
  - 5
    - Can the status indicator color be changed? In Microsoft Project 2003 - Can the color of status indicator check mark be changed or can the background be changed? Tag: How do I read the Start and End Time of a Day Tag: 110370
  - 6
    - The operation cannot be completed because the source file contains invalid project data or the total number of rows would exceed the limit of 1,048,000 rows in a project Hi, How can I repair a .mpp file with this error: "The operation cannot be completed because the source file contains invalid project data or the total number of rows would exceed the limit of 1,048,000 rows in a project" It looks like it has a circular reference, but I can't open it!!! Thanks! ~Luis Tag: How do I read the Start and End Time of a Day Tag: 110367
  - 7
    - actual end date should not change planned end date I need the program to leave the dates alone, I want to see my planned VS actual completion dates. If I enter an actual completion date it changes my orginal planned date. It doesn't make any sense, why even bother to have an actual completion column if it is just going to change the other column information. This makes the program useless. I hope you start sending patches out to fix these bugs. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=265c5254-a5eb-474f-b053-af1616fd8e68&dg=microsoft.public.project Tag: How do I read the Start and End Time of a Day Tag: 110359
  - 8
    - actual end date should not change planned end date I need the program to leave the dates alone, I want to see my planned VS actual completion dates. If I enter an actual completion date it changes my orginal planned date. It doesn't make any sense, why even bother to have an actual completion column if it is just going to change the other column information. This makes the program useless. I hope you start sending patches out to fix these bugs. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=e070d1f8-e0ee-4dba-9e81-edfcf982262d&dg=microsoft.public.project Tag: How do I read the Start and End Time of a Day Tag: 110358
  - 9
    - Create Combination View MS Project 2003 pro Is it possible to create a combination view where the upper view is a Gantt and the lower view is resource useage? But, I only want to see the resources assigned to the highlighed task in the upper view. Restated, the assignments of the highlighted task in the upper view, filter which resources and which resouce tasks are shown the the lower Resource Useage view. Thanks, Denis Tag: How do I read the Start and End Time of a Day Tag: 110356
  - 10
    - Indenting tasks and cannot outdent. While entering tasks and sub-tasks I accidentally indent a task. When I try to outdent the task it will not outdent. Is there any way to outdent the task after it has been indented? thanks, -- RWR Tag: How do I read the Start and End Time of a Day Tag: 110352
  - 11
    - Can't split task I have a schedule with custom fields. I enter a start date into Start1. I then calculate the duration1 field based on info in two other fields, (units per day / # of days) and calculate Finish1. My Gantt bars are set up to display these fields and it works fine. What I cannot do is right click on the task bar to split the task. It appears to work as I try to drag the split to where I want it but when I try and drop the split where I want it nothing happens. Is it because I am calculating these fields? Tag: How do I read the Start and End Time of a Day Tag: 110348
  - 12
    - How do I document days delayed due to weather? I work in construction, and I am curious as to if you are able to enter this type of delay in your project. Tag: How do I read the Start and End Time of a Day Tag: 110347
  - 13
    - Number of Resources not displaying if one I have show assignments in the options set to decimal. The number of required resources shows correctly in brackets after the resource name except when only one unit is required. In that case, no brackets or number of required units shows at all. Is that just the way it is when only one unit is required? Tag: How do I read the Start and End Time of a Day Tag: 110344
  - 14
    - Change to MS Project needed I created a large project, I needed to change an end date. My start date needs to stay where it is. I get a selection box that says I have choices to make, remove the must start on constraint or cancle the operation etc. If I select help the help button the box that pops up is for a constarined finsih date. The program help is crosswired. I need to be able to change the end dates as the project changes, if we are behind schedule I need to be able to show it. I need to turn off this garbage crosswired auto calculate move the dates around feature. My baseline will show the original dates. Please make this change soon. !!! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=0a3eb08a-b855-466d-aa7f-3976122aa690&dg=microsoft.public.project Tag: How do I read the Start and End Time of a Day Tag: 110340
  - 15
    - Struggling to get Project Data into Excel using OLE DB I have created a data source (an ODC File) using the wizards in Excel with Project OLEDB. The Test connection button works and when I open the file in Internet Explorer, Office Web Components allows me to create a PivotTable of the data. When I open it through Excel, Excel says the query did not run or the database table could not be opened: The connection is: Provider=Microsoft.Project.OLEDB.11.0;User ID="";Data Source="";Project Name=Z:\\My Documents\\H06802S.mpp;Enterprise Mode=False;Always Load=False;Initial Catalog=Z:\\My Documents\\H06802S.mpp;Persist Security Info=False;Enterprise RUID List="";Initial Catalog=(Default) The Command Type is Table The Command Text is Assignments Does anyone know what I need to do to get this to work? Have you got samples which do work? Thank you. Best Wishes, John. Tag: How do I read the Start and End Time of a Day Tag: 110339
  - 16
    - MS-Project task automatically in Outlook calendar I use Microsoft Project Manager. I also use Outlook. I would like to be able to put a task in Project Manager and have it show up in the Outlook calendar. Tag: How do I read the Start and End Time of a Day Tag: 110338
  - 17
    - change email format to display messages as they arrive Tag: How do I read the Start and End Time of a Day Tag: 110336
  - 18
    - Custom Toolbars, Global.mpt and the Global Enterprise Template Problem: Custom Toolbar reappears after deleting using organizer. Background: We have two Project Server environments, Test and Production. I developed a macro for a custom toolbar and made it part of global.mpt, my local global template. When ready to test and deploy in the Test environment, I copied it to the TEST Global Enterprise Template (GET) using the organizer as described here and elsewhere. I later deleted the custom toolbar and macros from the TEST GET, but it reappeared when I re-opened Project Pro. I deleted the custom toolbar again using the organizer, but it would reappear in the next session. I opened Project Pro in local mode (offline), deleted the toolbar again and it was gone for all subsequent sessions. Good! It was gone from TEST environment, too! However â?? argghhh! -- it reappeared when connecting to the PROD Project Server environment. It was never copied into the PROD GET. It does not appear in either TEST GET nor PROD GET organizer, nor in the global.mpt when in local mode. Is there a cache copy to delete somewhere? Does Project Pro combine the global.mpt and the GET into a cache that is subsequently loaded into Project Pro? BTW, a co-worker can not permanently delete the custom toolbar at all except when in local mode. In other words, the custom toolbar reappears in both TEST and PROD, but not local offline. -- Steve Tag: How do I read the Start and End Time of a Day Tag: 110335
  - 19
    - How do I set up automatic report generation and em using outlook I would like to automatically generate report using MSP 2003 that is automatically emailed to contacts using oulook. Tag: How do I read the Start and End Time of a Day Tag: 110334
  - 20
    - Print Project Calendars I have several Project Calendars and would like to b able to print them! Tag: How do I read the Start and End Time of a Day Tag: 110333
  - 21
    - how to implement inventory control using ms project 2000? Thank you in anticipation. Tag: How do I read the Start and End Time of a Day Tag: 110331
  - 22
    - How do I get a summary of how many people (i.e. resources) I need OK this must be simple - I cant believe that such a complex bit of software cant do this. I have a project, it involves using mainly people as resource, what I want to do is to produce a simple table or graph that tells me I need 2 people in week 1, 5 in week 2, 16 in week 3 etc, etc.... you get the idea. Its basic resource planning and all I seem to be able to get is a badly formatted bar chart showing over allocation. Please help me! Tag: How do I read the Start and End Time of a Day Tag: 110330
  - 23
    - Indenting while Importing Tasks I have imported hierarchically indented tasks from Excel. MS project has not identified automatically the tasks which were imported indented as Milestones, tasks, subtasks etc. Is there a way to automatically recognize the indented tasks ? Tag: How do I read the Start and End Time of a Day Tag: 110329
  - 24
    - Project Duration vs Actual working project days The project has duration of 110 days for example. The project commences in July 06 and finishes in January 07. MS Project calculates a total of 350 days. How do I exclude the periods for which the project has idle time, and for the duration to only show the actual working days of the project (total of 120, and not 350 days)? Tag: How do I read the Start and End Time of a Day Tag: 110328
  - 25
    - keyboard shortcut for outline Hello, 1. I want to assign a single keyboard shortcut for changing the level of subtask instead of project->outline->indent. How can I do this? 2. I want to change the level of tasks: suppose I have task A and set task B to be a subtask of A. Now I want to set B to have the same level with A. How can I do this? Best regards, Tag: How do I read the Start and End Time of a Day Tag: 110325

Can anyone help me with this problem: I would like to read the start
time and the finish time of a given day from a resource calendar using
VBA. For example, if on the 30/9/2006 the working time started at 7:00
am and finished at 5:00pm, then I would like to read 7:00am as start
and 5:00pm as end time for this day.

I can not find the vb syntax to read this. Thanks in advance.

Atish

Top

Re: How do I read the Start and End Time of a Day by Jan

Jan
Tue Sep 12 12:56:33 CDT 2006

Hi,
Look for help on Calendar.Period.Shiftn objects
HTH

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"Atish" <atishkumar@people.net.au> schreef in bericht
news:1158062445.151306.252700@m73g2000cwd.googlegroups.com...
> Can anyone help me with this problem: I would like to read the start
> time and the finish time of a given day from a resource calendar using
> VBA. For example, if on the 30/9/2006 the working time started at 7:00
> am and finished at 5:00pm, then I would like to read 7:00am as start
> and 5:00pm as end time for this day.
>
> I can not find the vb syntax to read this. Thanks in advance.
>
> Atish
>

Top