Skip to main content

Time worked multiply by hourly rate

  • June 11, 2018
  • 1 reply
  • 20 views

Nice day to all of you!

Please, how do I multiply (formula: {Duration field} * {Currency field}) the time worked (Duration field) by my hourly rate (Currency field)?

Output example: 2:00 * $50 = $100

To my surprise it is not possible.

Thanks for Your help!

1 reply

Forum|alt.badge.img+5
  • Inspiring
  • June 11, 2018

Durations are held internally as seconds, so

({Duration field}/3600) * {Currency field}

should do it.