Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |