Forum Discussion

MikeRedfearn's avatar
MikeRedfearn
Qrew Trainee
5 years ago

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

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
------------------------------
  • 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
    ------------------------------
    • MikeRedfearn's avatar
      MikeRedfearn
      Qrew Trainee
      Mark! Thank you so much! Worked perfect.

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