Subtract Timing of Format dd/hh/mm

Hello Guys,

I'm trying to subtract dates in 2 cells of format dd/hh/mm (days/hours/minutes)

any formula that can help me with this?

appreciate your help

I have 2 times in 2 cells of format dd:hh:mm (day:hours:minutes) like below
11:3:20
How could I Subtract both cells of the same format and return the time difference?
Example: 11:3:20 - 11:0:03 should return 0:3:17 (0 days 3 hours 17 minutes)

Thank you,

Please Login or Register  to view this content.

But I am not sure it will work with you regional settings. I afraid 13-01 is not 13 jan 2020 but error .

Try this:

Please Login or Register  to view this content.