ExcelBanter - Help with calculating time elapsed

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Help with calculating time elapsed (https://www.excelbanter.com/excel-worksheet-functions/453880-help-calculating-time-elapsed.html)

Jooniper

Help with calculating time elapsed

Hi all,

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).

Can anyone please help?

Many thanks,

Jooniper

Claus Busch

Help with calculating time elapsed

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

All times are GMT +1. The time now is 05:23 PM.