Our company has a form that it uses to review products (its basically a checklist of things to look for). They open a new review, go through the checklist for that particular product and then hit save. A timestamp is created each time a reviewer completes a review, however, we wanted to be able to track their productivity and the best way to do this was to time from when they started the review to when they completed the review.
Our form currently provides a time stamp of when the Reviewer selects a product ID, making it the start time.It then provides a time stamp of when the Reviewer goes through the checklist and hits save, i.e. this would be the end time.
The problem is not being able to capture the “seconds” in the time stamp for the start time, it only provides Hour and Minute of start time ....Also tried adding a duration calculation, however, the calc goes off of the rounded time figure as well. Looking for a way to either: Add the seconds to the Start time or Fix the duration calculation to provide duration between start time and end time that includes the seconds.