I have a formula duration field that totals hrs worked hh:mm:ss and I have a formula field that totals number of sales and I need to calculate the SPH, which would be [# SALES]/[HOURS WORKED], but that will not work. Advice??
Thank you so much!
------------------------------
Kim Cameron
Admin/Sales
Vacation Tour & Travel
Conway AR
15013295434
------------------------------
Question
Duration Formula
+5This topic has been closed for replies.
+24try this
[# SALES]/ToHours([HOURS WORKED])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
[# SALES]/ToHours([HOURS WORKED])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.