topic Re: Time Calculations in App Development

Time Calculations

Raju_6952 — Mon, 05 Feb 2024 17:17:36 GMT

Hi,

I have Incident_creation_time field in My data and need to calculate time remaining for each Incident since its created.

for example if creation time is 10:00PM then the remaining for closure is 30 minutes left (which means 10:30PM)Similarly if its exceeds 30 minutes it should show the time in negative value.

any suggestions would be appreciated.

Thanks,

Raju

Re: Time Calculations

Nagaraju_KCS — Mon, 05 Feb 2024 18:05:51 GMT

If you provide some sample data and output - that would be great and you will get quick response.

Re: Time Calculations

Raju_6952 — Tue, 06 Feb 2024 02:54:04 GMT

For example

Creation time,SLA remaining

06/02/12:00:00 Am,30 minutes (from the creation time),if 30 minutes is over due it should display as negative value let's if it's 30 minutes overdue then SLA remaining is -30 minutes.

Re: Time Calculations

Anil_Babu_Samineni — Tue, 06 Feb 2024 05:52:36 GMT

@Raju_6952 Not sure what ticket model you use (Ex, ServiceNow), in this you have default feature that shows accurate which in-build dashboard. If you load API's from ticketing system then I would guess like this.

If(FieldName<=[Your threshold fieldname], 'You have breached the ticket ' & Interval(FieldName-[Your threshold fieldname], 'mm')) & 'minutes'), 'You have left time to breach the ticket ' & Interval(FieldName-[Your threshold fieldname], 'mm')) & 'minutes'))

Re: Time Calculations

Raju_6952 — Tue, 20 Feb 2024 06:35:50 GMT

hI @Anil_Babu_Samineni ,

it's not ticketing tool and general tool. added logic to calculate the time remaining.

Thanks &Regards,

Raju

Re: Time Calculations

Anil_Babu_Samineni — Tue, 20 Feb 2024 06:39:46 GMT

@Raju_6952 Did you tried from my sample expression?