Forum Discussion

mbrawn's avatar
mbrawn
Frequent Visitor
8 years ago
Solved

Calculating Duration in Minutes & Seconds between 2 Columns

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

 

 

Need Help
  • jthomson's avatar
    jthomson
    8 years ago

    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

3 Replies

  • jthomson's avatar
    jthomson
    Icon for Solution Sage rankSolution Sage
    8 years ago

    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