September 20, 200520 yr hey everybody, i'm trying to create something simple that i know you all probably know how to do in a snap. i need a way to track how much time someone is spending doing certain tasks each week. what i envision is a simple table with 3 columns: date, time, and notes. But i obviously don't want to create a different field for each "cell" in this simple "table." How can i do this without creating a different table occurrence to track this information? or do i have to? thanks
September 20, 200520 yr Why don't you try creating two timestamp fields in the same table where you are keeping your task information. Record the first timestamp field as soon as the task is allocated to a person and when the person finishes the task, record the time in the second timestamp. Create a calculation field "calculate only when needed" to see the difference in hours between the two timestamps.
Create an account or sign in to comment