How to convert Estimated and Actual time as decimals for accurate time reports in Asana? | Scribe

    How to convert Estimated and Actual time as decimals for accurate time reports in Asana?

    • Google APIsGoogle APIs
    • Google DocsGoogle Docs
    • Google AccountGoogle Account
    • AsanaAsana
    1
    Navigate to "My Tasks".
    2
    Click "Customize".
    3
    Click "Fields".
    4
    Click "+Add".
    5
    Click "Create new".
    6
    Name the field "Estimated time (dec.)".
    7
    Click "Single-select".
    8
    Click "Formula".
    9
    Click "Advanced".
    10
    Click in the box and paste the following formula: [[( $1203413414962007 + 0 ) / 60]]
    11
    Click "Add to [organization.com](http://myvirtualpartnr.com)'s field library".
    12
    Click "Create field".
    13
    Click "+Add".
    14
    Click "Create new".
    15
    Name the field "Estimated time (dec.)".
    16
    Click "Single-select".
    17
    Click "Formula".
    18
    Click "Advanced".
    19
    Click in the box and paste the following formula: [[( $ACTUAL_TIME + 0 ) / 60]]
    20
    Click "Add to [organization.com](http://myvirtualpartnr.com)'s field library".