Forum Discussion
Time Tracking - Hours and Minutes between dates
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!
1 Reply
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:
