Skip to main content
Question

Using total duration field in a numeric formula

  • July 9, 2020
  • 0 replies
  • 78 views
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
------------------------------
This topic has been closed for replies.

  • AustinK
  • Quickbase Alumni
  • July 9, 2020
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.
Terms & ConditionsAccessibility statement