Help! Formula Trouble - Multiply Rate by Billable Hours

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 formulas, the “#Hourly” was the fix for that. I must have read it wrong.
I am versed in Excel, but new to the nuances.

Thank you again!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.