Hi,

Am Sun, 22 Oct 2017 10:51:34 +0100 schrieb Jooniper:

I am trying to calculate time elapsed.
Opened date - 02-07-2017 10:19:47
Closed date - 03-07-2017 11:14:18

I have tried Closed-Opened and it returns 54 minutes (which is obviously
wrong).

format the formula cell with [h]:mm:ss


Regards
Claus B.
--
Windows10
Office 2016