Calculating Duration in Minutes & Seconds between 2 Columns

[mbrawn]

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

[jthomson · Accepted 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

[mbrawn]

Thanks @jthomson - apparently not as some of the calls, somehow, have a start date greater than the end date...

[v-chuncz-msft]

@mbrawn,

Just use IF Function to find those rows.