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