ARTICLE · RESOURCE PLANNING · PROJECT TIME

Resource planning and project time tracking: capacity, staffing and approved hours in one place

In short: resource planning decides who works on which project, when and for how many hours; project time tracking shows how much of it actually happened. As long as the two live in separate Excel files, overbooking and unbilled hours only show up afterwards. In Dynamics 365 Project Operations the planned booking, the weekly time entry, the approval and the resulting cost and billable lines run on the same data.

In short

  • Resource planning: matching demand (which role, how many hours, when) with capacity (who is free), then booking.
  • Capacity planning: the same at team or role level, months ahead: will we have enough people for incoming projects?
  • Project time tracking: the hours actually worked, per project and task, with approval; this becomes cost and invoice.
  • Instead of Excel: conflict warnings, search by skill, utilization against a target, and one version of the truth about hours.
  • In Dynamics 365 this is Project Operations and its scheduling engine (Universal Resource Scheduling) – the same one field service uses.

Author: Norbert Madarász, Managing Director and Partner · Updated: 15 November 2026

What is resource planning, and how does capacity planning differ?

Resource planning works at project level: the project manager states which role, how many hours and which period the planned tasks need, and the resource manager assigns a named person. Capacity planning is the top-down view of the same thing: all demand in the company against the available hours of teams and roles, weeks and months ahead. The first answers “who works on this?”, the second “can we handle next quarter, or do we need to hire?”.

How do you build a resource plan?

  1. Demand: collect the required hours and period per role from the tasks in the project plan.
  2. Capacity: work calendars, vacation, absence and existing bookings show who has free hours.
  3. Matching: search for the right person by role, skill, language and organizational unit.
  4. Booking: first tentatively, then firmly; a firm booking consumes capacity.
  5. Tracking: compare recorded and approved hours with the plan; replan when they differ.

Why is Excel not enough for resource planning?

  • No conflict warning: if two project managers book the same person for the same week, the spreadsheet does not notice.
  • It goes stale: vacation, sick leave and project delays do not update the plan by themselves.
  • One owner: whoever maintains the file becomes the bottleneck; parallel editing creates versions.
  • Not linked to hours: the plan and the time actually recorded live in two sheets; comparing them is manual work.
  • No search by skill: who knows Dataverse and speaks German is in people’s heads, not in the system.

For a small team and a few projects, Excel or Microsoft Planner may be enough. Where work is sold by the hour and staffing directly drives revenue, planning and time tracking belong in one system.

Resource planning in Dynamics 365 Project Operations

TermWhat it meansWho uses it
Rolethe kind of work, e.g. developer, consultant, designer; price and cost are linked to the roleproject manager, resource manager
Generic resourcea placeholder in the team: “we need a developer for 40 hours”, without a name yetproject manager while planning
Resource requirement and requestthe requirement is the distribution of required hours over time, with skills; the request is the “envelope” that submits it to the resource managerproject manager → resource manager
Bookinga hard booking consumes capacity; a soft booking only adds the person to the team without consuming capacityresource manager
Schedule boarda timeline per resource: bookings, free capacity and overbooking shown in coloursresource manager, dispatcher
Characteristic and ratingskills, certificates, languages with a proficiency level; resources can be searched by themresource manager
Utilizationapproved billable hours relative to capacity, measured against a targetmanagement, resource manager

According to Microsoft Learn, a resource can be booked to a project in three ways: from the team member grid, on the schedule board, or from the project form. The project manager first assigns a generic resource to the tasks (“consultant, 80 hours”), generates a requirement from it and submits it as a resource request. The resource manager filters by role, skill and proficiency, and organizational unit in the scheduling assistant and books the right person. After a firm booking the named person replaces the placeholder in the team and on the tasks.

According to Learn, a soft booking adds the person to the team without consuming capacity, and the person cannot be assigned to tasks until the booking is firm. So you can show who you are counting on during the quote phase without blocking their calendar.

Utilization against a target

Project Operations calculates utilization from approved time entries: billable utilization = chargeable actual hours ÷ capacity, where capacity is work hours minus out-of-office and non-working days. The target is set on the role or individually on the resource. In the Resource Utilization view a cell is green when the target is met, yellow when it is up to 20 percentage points below, and red when it is further below.

The same scheduling engine (Universal Resource Scheduling) also dispatches service technicians; see field service with Dynamics 365.

Project time tracking and approval

Team members record time in a weekly grid: each row is a project, task, role and type, each column a day of the week. Rows can be copied, a whole week can be copied from the previous one, and time can be recorded at task, summary or project level. Submitted entries land on the approver’s Approvals page and can no longer be edited, only recalled.

  1. Draft: a new entry starts as Draft; only drafts can be deleted.
  2. Submitted: the team member submits entries one by one or in bulk.
  3. Approved or returned: the project approver accepts or returns the entry with a comment.
  4. Actuals: on approval, project hours become actual cost and – if the contract says so – billable lines.

Recorded vacation and absence appear on the schedule board as “Out”, so resource managers can plan around them. According to Microsoft Learn, cancelling an approval also negates the actuals already created, so it has a financial impact.

Time entry from Teams, with an AI agent

According to Learn, the time entry feature of the Time and Expense Agent (Time Entry Agent) is a production-ready preview from Project Operations version 4.140.0.239. With the team member’s consent the agent drafts time entries from bookings and tasks, sends alerts in Teams, and can add comments from Outlook calendar events. Because it needs calendar access, Microsoft requires a Microsoft 365 E5 licence for the agent user. On AI agents in general: AI agents and MCP for Dynamics 365.

Project time or working time records?

They are not the same. Working time records are an employer’s labour-law obligation: when an employee started and finished, and how long the breaks were. Project time tracking shows how much of the time worked went to which project and task, and how much of it is billable. Project Operations is built for the second purpose; if working time records are also needed, decide that separately during the rollout (HR system, access control, or a custom Dataverse table).

Excel, Planner or Project Operations?

CriterionExcel spreadsheetMicrosoft PlannerDynamics 365 Project Operations
Good forsmall team, a few projects, one ownertask and schedule planning in Microsoft 365project-based firms: quote, staffing, time entry, cost and billing in one place
Capacity and bookingmanual, nobody flags conflictstask assignment and workload view, without capacity bookingbooking by calendar and capacity, with overbooking warnings
Search by skillnonoby role, skill and proficiency, organizational unit
Time entry and approvalseparate sheet, summed up afterwardsno project time approvalweekly grid, submit, approve, and actuals (cost, billable lines) from it
Customer and quotein another systemnothe same customer and quote as in Dynamics 365 Sales

According to Microsoft’s lifecycle page, Project Online was retired on 30 September 2026. Where the project portfolio ran there, a decision is due now: Planner is enough for task planning, while for project-based staffing, time entry and billing Project Operations is Microsoft’s own path. Licensing, deployment types and the comparison with Business Central are covered in our Project Operations article; team members who only record time can use the Team Members licence described there.

Rollout step by step

  1. Analysis: roles, skills, organizational units, work calendars, approval rules, today’s spreadsheets and time tracking (requirements analysis).
  2. Master data: bookable resources, default role, utilization target, skills and ratings.
  3. Process: resource request, booking, time entry, approval, and if needed task assignment and queues for non-project work.
  4. Integration: finance system, HR, Teams, Outlook.
  5. Testing and training, then go-live and ongoing support.

Details: Microsoft Dynamics 365 consulting. For companies in the DACH region we work in German or English as a nearshore partner.

Frequently asked questions

What does resource planning mean?

Deciding who works on a project’s tasks, when and for how many hours. Demand (role, hours, period) is compared with available capacity, and then a named person is booked.

What is the difference between resource planning and capacity planning?

Resource planning is project-level and person-specific; capacity planning compares all demand of the company or a team with the available hours, weeks and months ahead.

How does project time tracking work in Dynamics 365?

Team members record hours in a weekly grid against project, task and role, then submit them. The project approver approves or returns them; approved hours become actual cost and billable lines.

Can time be recorded from Teams?

The Time Entry Agent (preview) drafts time entries from bookings and tasks and sends alerts in Teams; the team member reviews and submits them. An administrator has to enable the agent first.

How is utilization calculated?

Approved chargeable actual hours divided by capacity (work hours minus out-of-office and non-working days), measured against the target set on the role or the resource.

Which licence do people need who only record time?

According to the Microsoft Licensing Guide, users who only record and approve time can use the Team Members licence; project managers and resource managers need a full Project Operations licence. Details in our Project Operations article.

What happens to Project Online?

According to Microsoft’s lifecycle page, Project Online was retired on 30 September 2026. For task planning Microsoft points to Planner, for project-based staffing, time entry and billing to Dynamics 365 Project Operations.

Let’s talk about your project.

Tell us what you are planning and we will get back to you within a few days.

Get in touch

Cookie settings

Choose what you consent to. We remember your choice for 6 months; change it any time via “Cookie settings” in the footer.

Privacy notice