Discussions

Expand all | Collapse all

Using total duration field in a numeric formula

  • 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.