Error with forumla

Im getting an error when I use this formula and I have no idea why, appreciated if anyone can help me out.

Im trying to calculate the duration between 2 dates and times

A9 = 03/08/2021 15:21:00
K9 = 03/08/2021 16:47:00

Please Login or Register  to view this content.

The result looks like this: 0 days h hrs 1 min

This is the error I get but I cant seem to fix it
2.png

try this:

Please Login or Register  to view this content.

Thanks for your response, I still get the same error

Works fine for me:

Result is 0 days 1 hrs 26 mins

the issue may be incorrect formatting of the cells, try using a date format that includes the hours and minutes, not general or text.

Try changing the "," in JohnTopley's formula to ";".

I just copied the formula given in the post and changed ":" to ",": no problem.