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 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 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), ...Case Management Dashboard Statistics
This article explains where the statistics that appear on your Dashboard for Case Management come from. Active Clients - quick access to the organization's current client list. This is a count of client contacts with ONE OR MORE Case Plan records ...Reporting in Sumac Case Management for Health and Social Services
Sumac has many built-in reports, as well as precise searching and flexible export options to customize your reporting. Using search and export for custom ad-hoc reporting This article tells you how to search using the search panel. You can also ...Societ Academy - Sumac Case Management
Sumac Case Management Series This series of four short webinars will teach you everything you'll need to know about using Sumac for Case Management. We've kept each segment short so you can work these sessions into your schedule. You can register for ...Reporting in Sumac Case Management for Hospices
Sumac has many built-in reports, as well as precise searching and flexible export options to customize your reporting. Using search and export for custom ad-hoc reporting This article tells you how to search using the search panel. You can also ...
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.