How to calculate duration/set-up duration formula in Custom records
If you need to define a field for calculating duration - for example, to calculate the duration of a room booking in a Custom record designed to track room rental details - do the following:
1) Create a Count field for the Start Time (e.g. Count1), and put a check mark next to "Display as Time of Day."
2) Create another Count field for the End time (e.g. Count2), and put a check mark next to “Display as Time of Day."
3) Create a third Count field for the duration (e.g. Count3). For this field, put a check mark next to “Display as Duration." When defining this field, edit the "Formula or Checkbox Choices" field to enter the formula for the duration Count field is as follows:
(Count2-Count1)/1000
This will calculate the duration, in hours.
Our products got an upgrade!
Some screenshots and help videos have been made using older versions of our products. Though your version's colours and themes may appear different than what you see here, the instructions, links and advice in this article are still accurate and useful!
Related Articles
How to calculate duration/set-up duration formula in Case Management records
If you need to define a field for calculating duration - for example, to calculate the duration of a meeting between a client and their case worker - do the following: 1) Create a Count field for the Start Time (e.g. Count1), and put a check mark ...How to set up Course Registration Forms
When a student registers for a course, you might need to collect details such as allergies or medical alerts. You might also need a Release Form or to collect Emergency Contact information. Sumac makes is easy for you to collect this information ...How to personalize your favourite records when using Add to Contact
In the Sumac Contact list, the Add to Contact button allows you to add new records of many different types to a contact showing in your Contact list. The Add to Contact button is also available within every contact's record, on the History tab. When ...Volunteer Add On - Overview
The Volunteer Add-on has three components: • Volunteer Types • Volunteer Facts • Volunteer & Staff Tasks List Volunteer Types Volunteer Types are checkboxes in volunteers' contact records. In the contact record, on the Basic tab, you'll see the ...How to add a New Pledge
In your Sumac console, expand Fundraising, and choose Pledges. Click New to open a new pledge record. Once the new pledge record opens, select the contact who is making this pledge by clicking the contact icon. The Commitment Date for this pledge is ...
Societ Academy
Learn what you need to know, any time. Free!
- High quality training on demand - sessions are available every day, so you can access training that fits into your schedule.
- Training sessions that are easy to follow - helpful tips throughout each session, and access to training moderators ensure your questions get answered.
- A certificate of completion - you can request a certificate of completion for every session you attend.