Help

Re: Time worked multiply by hourly rate

1999 0
cancel
Showing results for 
Search instead for 
Did you mean: 
tomnaute
4 - Data Explorer
4 - Data Explorer

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 1

Durations are held internally as seconds, so

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

should do it.