Forum Discussion

RebekahAlcantar's avatar
RebekahAlcantar
Qrew Trainee
8 years ago

I am tracking aging of support tickets from two different systems.

I need help to create a formula to calculate a complex duration issue. I am tracking aging of support tickets from two different systems. Therefore, I have a total of 4 time stamps. ...
Formulas and functions
RebekahAlcantar's avatar
RebekahAlcantar
Qrew Trainee
8 years ago
Thanks so much!
I need to add one more line..

  • If 3 is blank, then calculate duration between 1 & 2
  • If 3 is NOT blank AND 4 is blank, then calculate duration between 1 & current date.
  • If  3  and  4 are not blank then calculate duration between 1 & 4
  • If  3  and  4 are blank then calculate duration between 1  current date

I tried to create a formula for the new line based on the current coding and kept hitting error messages.