Is it feasible to make duration type field to calculate in 8 hrs format instead of 24hrs format

kalyani23
Tera Contributor

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

6 REPLIES 6

RaghavSh
Kilo Patron

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

It is a field created in a custom table of type duration, please refer the screenshots below

 

kalyani23_1-1696924986800.png

 

kalyani23_0-1696924965283.png

 

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

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 ?