Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-17-2022, 02:43 AM
Zweebo Zweebo is offline Creating a custom field for tables in reports, showing the hours/week of a task Windows 11 Creating a custom field for tables in reports, showing the hours/week of a task Office 2019
Novice
Creating a custom field for tables in reports, showing the hours/week of a task
 
Join Date: Sep 2022
Posts: 4
Zweebo is on a distinguished road
Default Creating a custom field for tables in reports, showing the hours/week of a task


Hi everyone, I'm working on some rapports and I would like to have a row that indicates the hour per week.

For example, The duration of a task might be 2 weeks, and the work might be 40 hours,
I would like the custom field to calculate a simple divying up of the work effort, per week, in this case it would be 20 hrs per week. If it was 5 weeks and 50 hours, it would show as 10 hours a week. From there it should be easy to get it into a table row, showing it per task as a list.
It's quite likely this must be possible using the custom field programming right? I've been having a look at it but I can't figure it out myself.
Any help would be tremendously appreciated.
Reply With Quote
  #2  
Old 10-17-2022, 07:08 AM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline Creating a custom field for tables in reports, showing the hours/week of a task Windows 10 Creating a custom field for tables in reports, showing the hours/week of a task Office 2019
Advanced Beginner
 
Join Date: Mar 2021
Location: UK
Posts: 72
ProjectPlanner is on a distinguished road
Default

Try this formula.

Formula assumes you are using the Standard calendar of 8 hours per day & 5 days per week.

IIf([Milestone],0,([Work]/60)/([Duration]/(2400)))



=jerome
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
3 Week Look Ahead-Custom Field/View naparkins1 Project 0 05-08-2020 12:00 PM
Creating report showing only part of work from one resource at a task with more resources working at daniwei Project 2 06-24-2018 03:05 PM
Creating 2 percentage fields to show the progress from week to week Loay harhash Project 0 04-03-2018 03:26 AM
Creating a custom field for tables in reports, showing the hours/week of a task Resource Reports not showing Sub project Resource group hours RichB Project 3 02-24-2017 08:55 AM
Creating a custom field for tables in reports, showing the hours/week of a task Custom field formula not working at summary task level abw1987 Project 3 10-05-2011 07:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:48 AM.


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