Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-15-2014, 07:43 AM
ketanco ketanco is offline showing months in another duration column Windows 7 64bit showing months in another duration column Office 2010 64bit
Expert
showing months in another duration column
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default showing months in another duration column

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?
Reply With Quote
  #2  
Old 12-17-2014, 01:10 PM
JulieS JulieS is offline showing months in another duration column Windows 7 64bit showing months in another duration column Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You cannot have things show in "whole months". What do you mean - you want to see the month that the task starts? ends?
Reply With Quote
  #3  
Old 01-14-2015, 07:20 AM
ketanco ketanco is offline showing months in another duration column Windows 7 64bit showing months in another duration column Office 2010 64bit
Expert
showing months in another duration column
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 01-14-2015, 07:54 AM
JulieS JulieS is offline showing months in another duration column Windows 7 64bit showing months in another duration column Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

What are you going to use for your definition of month? 20 working days? 30 calendar days?
Reply With Quote
  #5  
Old 01-15-2015, 07:38 AM
ketanco ketanco is offline showing months in another duration column Windows 7 64bit showing months in another duration column Office 2010 64bit
Expert
showing months in another duration column
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

30 calendar days would be more accurate. i would use that
Reply With Quote
  #6  
Old 01-15-2015, 07:52 AM
JulieS JulieS is offline showing months in another duration column Windows 7 64bit showing months in another duration column Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

In a text field:

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

You're welcome.
Reply With Quote
  #7  
Old 01-19-2015, 04:38 PM
ketanco ketanco is offline showing months in another duration column Windows 7 64bit showing months in another duration column Office 2010 64bit
Expert
showing months in another duration column
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

thanks a lot
Reply With Quote
  #8  
Old 01-20-2015, 06:21 AM
ketanco ketanco is offline showing months in another duration column Windows 7 64bit showing months in another duration column Office 2010 64bit
Expert
showing months in another duration column
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

thanks it worked but it doesnt show the value for summary tasks. what can I do?
Reply With Quote
  #9  
Old 01-20-2015, 07:27 AM
JulieS JulieS is offline showing months in another duration column Windows 7 64bit showing months in another duration column Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
showing months in another duration column entering duration in months ketanco Project 1 12-17-2014 01:09 PM
showing months in another duration column 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft