Discussions

Expand all | Collapse all

Create a new field that takes the number from another field, then divide to calculate hours.

  • 1.  Create a new field that takes the number from another field, then divide to calculate hours.

    Posted 27 days ago
    Hello -

    I am trying to create a new field that tells me the total number of hours that a job will take. We already have a numeric field that calculates the total number of minutes required to do a job, which pulls that data internally from another relationship.

    But I would like to create a new field that takes those number of minutes from the other field, and then divides it by 60 (60 minutes in a hour), to then give me the total number of hours it will take to complete a job.

    Can you advise which field type and the formula to do something like that?

    Thank you in advance!

    ------------------------------
    Mike Redfearn
    ------------------------------


  • 2.  RE: Create a new field that takes the number from another field, then divide to calculate hours.

    Posted 27 days ago
    If the Minutes field is a numeric field type then the formula for [Hours] will be

    [Minutes] / 60


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Create a new field that takes the number from another field, then divide to calculate hours.

    Posted 25 days ago
    Mark! Thank you so much! Worked perfect.

    ------------------------------
    Mike Redfearn
    ------------------------------