How do I subtract two string timestamps in Qlik Sense?

[aidalj28]

Hello,

I have two timestamps as a string coming from data base. I want to subtract them, but I cannot get the desired output.

I have e.g.,:

Begin

2022.01.13 00:00:00

End

2022.01.13 23:30:02

I tried this:

=Time#(Begin) - Time#(End) as well as =Timestamp#(Begin) - Timestamp#(End), but i am not getting anything except "-".

Can you please help me, how can I subtract those strings and get their difference in minutes?

Thank you!

[rwunderlich · Accepted solution]

=Interval(Timestamp#(End, 'YYYY.MM.DD hh:mm:ss') - Timestamp#(Begin, 'YYYY.MM.DD hh:mm:ss'), 'hh:mm:ss')

-Rob