Forum Discussion
Datetime - seconds
If your call end time is a DateTime column and the duration in seconds is a number column, you can use this formula in a custom column in M/query. Just add a custom column and use this formula.
=[CallEnd]-#duration(0,0,0,[info2])
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Hi, mahoneypat ,
Tks!! The formula didn't work. I tried to convert the info2 column to an number, but it still didn't work. See the pictures:
If your call end time is a DateTime column and the duration in seconds is a number column, you can use this formula in a custom column in M/query. Just add a custom column and use this formula.
=[CallEnd]-#duration(0,0,0,[info2])
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Yesssss Its work!!!!1 Thanks!!!!!!!!!
Glad you got it working. What was causing the error?
If that approach worked, please mark it as solution. Kudos are appreciated too.
Regards,
Pat