Calculate difference between Timestamps with above

[amber2000]

Hi Everyone,

I want to calculate the difference between 2 times based on the field SSCC_OUT.

I have 2 fields with a Time Stamp but the are identical on the same row.

Example:

SSCC_OUT                    StartingTime          EndingTime          Time_Diff

112345030000034095           22:10:27               22:10:27             00:00:00

112345030000034095           22:11:10               22:11:10              00:00:00

Example of what I would like it to be:

SSCC_OUT                    StartingTime          EndingTime          Time_Diff

112345030000034095           22:10:27               22:10:27             00:00:00

112345030000034095           22:11:10               22:11:10              00:00:43  (difference with the above function)

I've attached a qvw with my efforts on the above() function and so far the result stays 00:00:00

Can anybody help me please?

Kind regards,

Monique

[amber2000]

This solved the problem completely.

Thank you for this solution.

Kind regards,

Monique

[amber2000]

Sunny,

Thanks a million for helping me, you solved this problem for me and I really appreciate what all of you are doing for us who aren't so advanced with the Qlikview tech.

Kind regards,

Monique

[sunny_talwar]

I suggest marking any helpful answers to highlight those for future reference and to reward contribution.

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks,

Sunny