How do I subtract the ticket end time from 12:00:00 AM

[Anonymous]

I need to calculate the ticket end time before 12 AM. So that I can get the hours spent on the ticket during one day.

Any help would be appreciated

@AlB @amitchandak

[Anonymous]

The result I need is Ticket end time on or before 23:59:59 PM on a specific date.

Example:- if a sepcific ticket is worked from 25/11/2020 9:15 PM to 26/11/2020 3:15 AM

Ticket end time on or before 23:59:59 PM should come under 25/11/2020 and on or after 12 AM should be calculated under 26/11/2020.

Ticket ID	start_time	end_time
1	02/09/2020 17:04	03/09/2020 02:17
2	17/05/2020 20:20	18/05/2020 05:29
3	11/08/2020 20:10	12/08/2020 05:19
4	01/07/2020 13:31	01/07/2020 22:40
5	21/09/2020 13:24	21/09/2020 22:35
6	27/09/2020 10:55	27/09/2020 20:15
7	05/08/2020 13:55	05/08/2020 23:03
8	16/07/2020 13:56	16/07/2020 23:05
9	24/07/2020 13:58	24/07/2020 23:08
10	21/08/2020 10:00	21/08/2020 19:14
11	23/06/2020 21:01	24/06/2020 06:16
12	25/06/2020 20:49	26/06/2020 06:03
13	20/08/2020 21:03	21/08/2020 06:11
14	24/07/2020 11:00	24/07/2020 20:13
15	01/10/2020 10:54	01/10/2020 20:07
16	01/05/2020 23:59	02/05/2020 09:09
17	29/09/2020 22:17	30/09/2020 07:28
18	05/03/2020 23:39	06/03/2020 08:58
19	09/01/2020 13:38	09/01/2020 22:51

This is what I am trying to achieve, if you can help me with this 

[amitchandak]

@Anonymous , I think this was asked previously too.

How do I know the time spend?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.