- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Hello,

I need to calculate the time spend since opening the ticket (Incident) till resolving it, there are two fields (open time, Resolved time)

what I need is to get the time difference and input it in another field.

Is there a way to do that, because I have tried to do the calculation through fd and failed.

Thanks.

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Just put like,

spend.time in $file= resolved.time in $file - open.time in $file

hth,

Assign Kudo, if found post useful and mark it accepted if solves the issue.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Just put like,

spend.time in $file= resolved.time in $file - open.time in $file

hth,

Assign Kudo, if found post useful and mark it accepted if solves the issue.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

##
Re: HPSM Calculate time spend till Resolving a ticket

Thanks for that so much 🙂

it worked with me, but only when its Resolved, once closed the field gets blank although it is the same form and all conditions in the "Calculation" tab (fc) is set to true.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

##
Re: HPSM Calculate time spend till Resolving a ticket

So in that case put condition in update coulmn like,

nullsub(status in $file0, "")~="resolved" and (nullsub(status in $file, "")="resolved" or nullsub(status in $file, "")="closed")

hth,

Assign Kudo, if found post useful and mark it accepted if solves the issue.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

##
Re: HPSM Calculate time spend till Resolving a ticket

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

##
Re: HPSM Calculate time spend till Resolving a ticket

Assign Kudo, if found post useful and mark it accepted if solves the issue.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

##
Re: HPSM Calculate time spend till Resolving a ticket

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

##
Re: HPSM Calculate time spend till Resolving a ticket

Assign Kudo, if found post useful and mark it accepted if solves the issue.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

##
Re: HPSM Calculate time spend till Resolving a ticket

yeeeeeeh, it worked!

Thanks so much Piku 🙂

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

##
Re: HPSM Calculate time spend till Resolving a ticket

Hello again Piku,

I have found that the time spent field we created keeps counting time, meaning that whenever I access the ticket that field shows a different value each time which is not appropriate.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

##
Re: HPSM Calculate time spend till Resolving a ticket

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

##
Re: HPSM Calculate time spend till Resolving a ticket

Hi,

Can you provide me the screenshots that how you did the configuration.