Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
I have 2 columns, both of which are Date/Time (DD/MM/YYYY HH: MM: SS). They are named SessionIDTime and SessionEndTime.
These are from a call report table and I need to be able to use a function to determine the minutes and seconds between the Call Start and End times in order to calculate total call times per person.
I've seen a number of threads with similar questions, but not one that specifically calculates minutes and seconds. Also, and at the risk of sounding obvious, some calls may be over 1 hour in duration.
Thanks,
Matt
Solved! Go to Solution.
Does DATEDIFF(SessionIDTime, SessionEndTime, second) produce a correct value for the number of seconds of each call? If so that's half the battle, you can then look to get the number of minutes of the call by using something like quotient(newcolumnwejustmade, 60)
edit - and the number of seconds similarly except using mod rather than quotient
Does DATEDIFF(SessionIDTime, SessionEndTime, second) produce a correct value for the number of seconds of each call? If so that's half the battle, you can then look to get the number of minutes of the call by using something like quotient(newcolumnwejustmade, 60)
edit - and the number of seconds similarly except using mod rather than quotient
Thanks @jthomson - apparently not as some of the calls, somehow, have a start date greater than the end date...
Just use IF Function to find those rows.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |