Hi there! I’m new to this, so I’m sure this is something very simple that I’m missing. I’m simply trying to multiply a rate ($ number column) by the time tracking hours. I keep getting wild results.
I’m using this formula:
And getting this result (formula column is named “Invoice”):
I’m sure I’m missing something obvious, but I can’t figure out what I’m doing wrong. Thanks for your patience and help!
Hey @loisamarie this is a tricky one.
Because ‘Billable’ in your case is a summary of a timetracking column the value shows to the formula in ‘seconds’. So the invoice amount of 482000 is what it would cost to charge $25 a second.
If you divide by 3600 (60m * 60s) then you should get the correct amount in the invoice column.
Also I just use the regular math functions rather than the spelled out ones.
Try this formula: ROUND({Billable}/3600*{Hourly Rate},2)
Hope that works for ya!
Thank you, it solved it! I thought in looking up Monday.com formulas, the “#Hourly” was the fix for that. I must have read it wrong.
I am versed in Excel, but new to the Monday.com nuances.
Thank you again!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
