Microsoft Office Forums - View Single Post - Creating a custom field for tables in reports, showing the hours/week of a task

Thread: Creating a custom field for tables in reports, showing the hours/week of a task

View Single Post

Old

10-17-2022, 07:08 AM

ProjectPlanner ProjectPlanner is offline

ProjectPlanner is offline

ProjectPlanner uses Windows 10

Windows 10 ProjectPlanner uses Office 2019

ProjectPlanner uses Office 2019

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