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.
Raghav
MVP 2023
- 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.
Raghav
MVP 2023
- 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 ?