Time Tracking - Hours and Minutes between dates

[PBI_Rookie_19]

Hi ! I need help. This might seem basic for most of you, but this ain't clicking with my brain.

We have a ticketing tool that where we want to look how much time an agent spends on a ticket from open to closed status.

Column 1 is called Start Date and is formatted as example 8/16/23 6:13:00 AM

Column 2 is called Close Date and is formatted as example 8/16/23 6:58:00 AM

Column 3 is called Tech and this shows the technicians first and last name

I understand that there are 45 mins between the open and closed date for this example. My issue is that I want to visualize this for our team and list out all of our agents and their time spent using a slicer. I'd love for this to be shown in "hh:mm:ss" if possible.

My data will begin on 1/1/23 and will continue into 2024. 

I've looked at using the DATEDIFF function, but it's not really showing me exactly how I need to visualize it. If anyone out there could give me step by step info with screen shots or some DAX I'd greatly appreciate it. Thank you!

[danextian]

H @PBI_Rookie_19 ,

You can create a calculated column to get the difference between two timestamps and then format it as hh:mm:ss. A simple endcolumn - startcolumn shoul do.

Please note the slicer can accept time format as a dropdown - using the between option will return dates instead.  Please see samples below: