Skip to main content
Question

Calculating time based on a Task

  • August 5, 2019
  • 0 replies
  • 65 views
I have a Task Name field that is a drop down with about 12 options. I have a Task Count field wherein the user inputs how many times they performed that task. I have a Task Time field that will multiply the Task Count field by a time value assigned to the Task Name. The trick is that each task in the drop down will have a different amount if time to complete. How would I be able to calculate the Task Time based on the time for each of the drop down tasks?
 
      This topic has been closed for replies.

      No Problem.

      Your task name is probably just a down and dirty multiple choice field.  You will need to convert that to being a lookup field from a relationship and then you can look up the std time per task. 

      Make a new table called Standard Tasks with two fields, Task Name and Task Time (a numeric field of the # of minutes).

      Set the Key field to be the task name

      Copy the 12 multiple choices onto your clipboard off the multiple choice field properties.

      Use import export to import them into your Standard tasks table. 

      Make a relationships where 1 Standard Task has many detail records (not sure what your current table is called), but do not initially create any lookup fields when you make the Relationship.  The go back and lookup the standard Task Time down into your details table.

      Now you can make your formula with varying Standard Task times per task Types.
      Hi Austin, Thank you. Two questions...1. the numbers you have in the first formula 2,4,3,7, are they meant to represent the amount of time for that task? and 2. I will have 12-15 lines for tasks, do I duplicate this formula for each "Task Time" field?
      I think that Austin withdrew his response as a Relationship is a better way to go for future sustainability of the app, less maintenance and more visibility into the std times.
      Sounds good. I'll start building this out but I may have a question or two along the way. Thanks again for the help.
      Terms & ConditionsAccessibility statement