# Discussions

View Only

## Using total duration field in a numeric formula #### Tanner Pruitt29 days ago • #### 1.  Using total duration field in a numeric formula

Posted 29 days ago
Hello,

I was wondering if anyone could help me figure out how to use the value in a total duration summary field as a numeric value to multiply it by a rate to produce a total.

For example, if we have spent 12 total hours on a task or project, and want to know how much this has cost. I am needing to multiply this 12 hours by a labor rate to produce a total cost.

The formula that would make sense to me, is Tonumber [Total Time Allocated]*(Rate)....

This however is not working.

------------------------------
Tanner Pruitt
------------------------------

• #### 2.  RE: Using total duration field in a numeric formula

Posted 29 days ago
ToHours([Total Time Allocated])*[Rate]

The ToHours part takes your duration and converts it into hours. It does take minutes into account. So 55:50 duration becomes 55.8333333 hours.

That should work depending on what your field is. I would think you want a Formula Numeric for this.