Forum Discussion

KimCameron2's avatar
KimCameron2
Qrew Trainee
5 years ago

Duration Formula

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 tha...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
try this

[# SALES]/ToHours([HOURS WORKED])

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • KimCameron2's avatar
    KimCameron2
    Qrew Trainee
    5 years ago
    Perfect....thank you so much!

    ------------------------------
    Kim Cameron
    Admin/Sales
    Vacation Tour & Travel
    Conway AR
    15013295434
    ------------------------------