How to convert Estimated and Actual time as decimals for accurate time reports in Asana?
Barbara Elena Ramirez
21 steps
32 seconds
Google APIs
Google Docs
Google Account
Asana
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".
21
Click "Create field".
How to convert Estimated and Actual time as decimals for accurate time reports in Asana?
Barbara Elena Ramirez
21 steps
32 seconds
Google APIs
Google Docs
Google Account
Asana
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".
21
Click "Create field".
