Follow
Hours Field Calculation Not Showing Correct Results

Question

On a project report I have a calculation that subtracts Actual hours (2) from Planned hours (4). The result I am getting is 120 when it should be 2. Why? Below is my calculation:

SUB(workRequired,actualWorkRequired)

Answer

Fields using hours in Workfront are stored in minutes, so when using the field in a calculation the result will be in minutes. To do this you will need to divide the result of the calculation by 60.

SUB(workRequired,actualWorkRequired)/60