showing months in another duration column

ketanco · #1 12-15-2014, 07:43 AM

i want to add a column so that although in enter durattion in days, that other column will show duration in whole months. how can i do that?

JulieS · #2 12-17-2014, 01:10 PM

You cannot have things show in "whole months". What do you mean - you want to see the month that the task starts? ends?

ketanco · #3 01-14-2015, 07:20 AM

i do not want to see a specific month. i want to see the duration in terms of months. right now it shows in days

JulieS · #4 01-14-2015, 07:54 AM

What are you going to use for your definition of month? 20 working days? 30 calendar days?

ketanco · #5 01-15-2015, 07:38 AM

30 calendar days would be more accurate. i would use that

JulieS · #6 01-15-2015, 07:52 AM

In a text field:

Round(([Duration]/[Minutes Per Day])/30,2) & " Months"

You're welcome.

ketanco · #7 01-19-2015, 04:38 PM

thanks a lot

ketanco · #8 01-20-2015, 06:21 AM

thanks it worked but it doesnt show the value for summary tasks. what can I do?

JulieS · #9 01-20-2015, 07:27 AM

In the Custom Fields dialog under Calculation for group and summary rows select "Use Formula".

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
entering duration in months	ketanco	Project	1	12-17-2014 01:09 PM
Inconsistent Duration column for the same date ranges	ravl13	Project	3	07-28-2014 05:16 PM
Excel Formula Showing Revenue Recognition Based on Days and Months	stratcat	Excel	4	03-16-2014 10:09 AM
Change Resource Time vs. Duration when Updating Work column	lylel	Project	3	07-23-2012 06:09 PM
Setting up recurring months to skip some months etc.	dwelch@ykfireprevention.c	Outlook	0	11-30-2010 10:15 AM