Can someone show me how I can calculate the elapsed time from the time a ticket is opened to the time a technician assigns the ticket to himself? The fields I can use to achieve this time difference is the Creation field and the assignment field. The creation field is a date field while the assignment fieild is a checkbox field. I need to show the output in time showing the time it took for the ticket to be acknowledge/assigned to someone?
Please help.
Subject: Elapsed time Calculation
theres is an example in notes help, just for these things and plenty of post if you search this forum
Subtract the 2 time fields gives you an answer in seconds. then do the math.
Subject: Elapsed time Calculation
i’ve just done this exact thing.i searched the forum and the help for a little inspiration and finally came up with my “elapsed time” displaying in the format…
2d 14h 12m 32s
if you wish, email me at ascullenhotmailcom to get you started on your own.