Time Calculations

[Raju_6952]

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

[qv_testing]

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

[Raju_6952]

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.

[Anil_Babu_Samineni]

@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'))

[Raju_6952]

hI @Anil_Babu_Samineni ,

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

Thanks &Regards,

Raju

[Anil_Babu_Samineni]

@Raju_6952 Did you tried from my sample expression?