Calculating Sum of Duration From Multiple Time Stamps

If you do not need to keep the Start/Stop timestamps for historical purposes, you can set it up like this:

• Start Button - API to push current date/time to Start field, Update Hours Worked with Hours Update, and clear the Stop and Time fields
• Start - Date/Time field to accept current date/time from Start Button
• Stop Button - API to push current date/time to Stop field
• Stop - Date/Time field to accept current date/time from Stop Button
• Time - Numeric or Duration Formula (depending on what you need) to calculate difference between Start and Stop
• Hours Worked - Numeric or Duration field (depending on what you need) to capture cumulative time spent on task
• Hours Update - Numeric or Duration Formula (depending on what you need) to calculate cumulative time spent on task (Time + Hours Worked)

I use this process on Timesheets when the client does not need to maintain individual Start/Stop records. Of course, this is the manual process, but you could adapt it fairly easily for your automated process.

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------