Is it feasible to make duration type field to calculate in 8 hrs format instead of 24hrs format
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2023 12:43 AM
Hi ,
we have a requirement , in which the duration field should calculate in 8 hrs format , instead of 24 hrs format .
Is it feasible can u confirm. if so please guide.
example I have given value : 0 days 25 hours 0 Minutes 0 seconds .
after saving it got converted to 1 day 1 hour .
but we need to show it as 3 days , as part of requirement . as it is related to a course completion. where 24 hrs format not suitable.
Thanks & Regards,
Kalyani
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2023 12:56 AM
which table are you referring to?
If this is SLA definition table define the schedule there, if your schedule if of 8 hours it will pick up accordingly.
You can test this in SLA definition table.
Please mark the answer correct/helpful accordingly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2023 01:04 AM
It is a field created in a custom table of type duration, please refer the screenshots below
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2023 01:11 AM
So probably you need a schedule field here as well. The schedule will be a reference field or you need to write a BR where you will have to specify the 8hrs schedule.
This is already working in OOB SLA definition table, you can take code from there and modify it accordingly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2023 01:23 AM
Actually , the duration field is not for calculating sla , its for tracker purpose and it should display in 8 hrs format . can that be done ?