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 that will not  work.  Advice??



Thank you so much!

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

2 Replies

Sort By
  • 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
      ------------------------------