Skip to main content
Question

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

  • October 30, 2020
  • 0 replies
  • 25 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------