Discussions

Expand all | Collapse all

Duration Formula

  • 1.  Duration Formula

    Posted 14 days ago
    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
    ------------------------------


  • 2.  RE: Duration Formula

    Posted 14 days 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
    ------------------------------



  • 3.  RE: Duration Formula

    Posted 14 days ago
    Perfect....thank you so much!

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