Forum Discussion

TannerPruitt's avatar
TannerPruitt
Qrew Member
5 years ago

Using total duration field in a numeric formula

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
------------------------------
Formulas and functions

1 Reply

Sort By
  • AustinK's avatar
    AustinK
    Qrew Commander
    5 years 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.