I have a table:
| ticket_id | ticket_status | status_changing_date |
|---|---|---|
| a11f00 | take to work | 05:00:00 |
| a11f00 | closed | 05:02:00 |
I want to find the difference (closing time – take to work time), that is 05:02:00 – 05:00:00. What script can I write? Or can this be done in Excel?
Thank you!