Issue with timestamp

[Anonymous]

i need to subtract Response time from the difference of Opened and Resolved timestamps.

e.g Opened date - 11/17/2016 5:55:00 AM

Resolution date - 12/9/2016 12:00:00 AM

Response duration - 48:00:00

i used the formula =[Resolution Date]-[Opened Date]-BPS_Response_TimeStamp and gives the result but i am not able to convert it into a timestamp format.can anybody please help?

[tresesco]

Yes, interval() would be ideal. However, with that too, format 'DD/MM/YYYY hh:mm:ss' doesn't make much sense. The time difference would never be converted to month or to year.

[jonathandienst]

I do agree that DD/MM/YYYY does not make much sense with Intervals. I am not even sure if this case is handled properly (whatever that may be). I was paying attention to the difference between TimeStamp() and Interval().

So this should probably be:

=Interval([Resolution Date] - [Opened Date] - BPS_Response_TimeStamp, 'D hh:mm:ss')

[#4]

Me too wait for the solution