Save time in the field and empower your business to make data driven decisions to identify bottlenecks and improve processes.
Calculating with Time Fields
Calculating time can be sorted into two broad categories: calculating time within a 24 hour period or calculating time across more than one day.
Calculating Time within One Day
Calculating Time within One Day
Total time onsite is a simple calculation that has multiple practical applications and is a data point that can be used to make data driven decisions and process improvements. This solution requires two Time fields and one Calculation field.
- Add two Time fields and a Calculation field to you form using your preferred method.
- Label the first time field, "Start Time," the second time field, "End Time," and the calculation field, "Total Time Onsite."
- Select "Start Time" to open Field Settings in the left panel. The Style defaults to AM/PM but can be adjusted to another preferred format.
- The Default Value will be Current Time but this can be changed. Determine the best default time based on when the user will complete this form for the best user experience. Current Time for the start of the day or No Default (Blank) for the end of the day. Custom Time may be too specific for most users but could also be edited by the user as long as it is not set to Read Only.
- Select "End Time" to open Field Settings in the left panel. Determine the appropriate Style and Default value.
- Select "Total Time Onsite" or the orange triangle beside the field to open Field Settings.
- Under Calculation, expand the first drop down and select "End Time."
- Click the Subtraction symbol to change the operator.
- Expand the second drop down and select "Start Time."
- Expand the Format drop down to change the format of the calculation from the default to one of the time formats: HH:MM, HH:MM:SS, or MM:SS.
- Save and Publish to test it on mobile.
Calculating Time Across Days
Calculating Time Across Days
Calculating time across several days is also possible with a simple expansion to the calculation. This solution requires two Date fields, two Time fields, and one Calculation field.
- Add two Date fields, two Time fields (alternating Date and Time), and a Calculation field to you form using your preferred method.
- Label the first date field, "Start Date," the first time field, "Start Time," the second date field, "End Date," the second time field, "End Time," and the calculation field, "Total Time Onsite."
- Select "Start Date" to open Field Settings in the left panel. The Style defaults to MM/DD/YYYY but can be adjust to another preferred format.
- The Default Value will be Current Date but this can be changed. Determine the best default date based on when the user will complete this form for the best user experience. Current Date for the same day or No Default (Blank) for a different day.
- Select "Start Time" to open Field Settings in the left panel. The Style defaults to AM/PM but can be adjusted to another preferred format.
- The Default Value will be Current Time but this can be changed. Determine the best default time based on when the user will complete this form for the best user experience. Current Time for the start of the day or No Default (Blank) for the end of the day. Custom Time may be too specific for most users but could also be edited by the user as long as it is not set to Read Only.
- Select "End Date" to open Field Settings in the left panel. Determine the appropriate Style and Default value.
- Select "End Time" to open Field Settings in the left panel. Determine the appropriate Style and Default value.
- Select "Total Time Onsite" or the orange triangle beside the field to open Field Settings.
- Under Calculation, expand the first drop down and select "End Date."
- Leave the operator as Addition.
- Expand the second drop down and select "End Time."
- Click Add Value.
- Click the Subtraction symbol to change the operator.
- Expand the third drop down and select "Start Date."
- Click Add Value.
- Click the Subtraction symbol to change the operator.
- Expand the fourth drop down and select "Start Time."
- Expand the Format drop down to change the format of the calculation from the default to one of the time formats: HH:MM, HH:MM:SS, or MM:SS.
- Save and Publish to test it on mobile.
Calculation Time Formats on Mobile
Did we answer your question?
We'd really appreciate your feedback! Please leave your suggestions for improvement in the comments or let us know what you're looking for so we can assist you better. We want to help, but we need to understand your needs!
Comments
0 commentsPlease sign in to leave a comment.