MikeRedfearn
5 years agoQrew Trainee
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
------------------------------
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
------------------------------