Skip to content
ProjectControls.com
Microsoft Project

Convert duration days in duration hours

In the Open Standard
Daniel MoraisMember for 8 years 5 months
Created
2
4
0

Hi Everyone,

Somebody knows how write one formula to change the duration days to duration in hours? When changed from options >> schedule the change is only on the resume, I need to change the tasks too but using the tasks calendar information into the formula.

Best Regards,

Daniel

Save Follow Follow forum Report
Reply New topic

2 replies

Oldest first
  1. 0
    Rodel Marasigan ·
    #1

    Hi Daniel,Easy....first you

    Hi Daniel,

    Easy....first you have to change the settings as follows:

    Select File Options -> Schedule then change 
     - Duration is Enter in Hours
     - Work is Enter in Hours

    Once done close the settings window.

    Then show the column Work (This should shows as hrs). Then highlight the whole column of Durations and press "Ctrl+C" to copy the duration in days. Select or click column Work heading to highlight and press "Ctrl+V" to paste the value. It will now automatically converted to hours.

    Once done do the same in reverse. Copy Work column and paste it to Duration column and you will have all durations in hours.

    You can fill zero again the Work column or leave it if you want some hours spread in timeline without resources.

    Report
  2. 0
    Daniel Morais ·
    #2

    Hi Rodel,Thank you very much,

    Hi Rodel,

    Thank you very much, it works very well.

    Kind regards,

    Daniel Morais

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?