| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Elapsed Time | Excel Worksheet Functions | |||
| Calculating elapsed time | Excel Discussion (Misc queries) | |||
| Calculating Time elapsed | Excel Worksheet Functions | |||
| Calculating elapsed time | Excel Worksheet Functions | |||
| Calculating a rate for elapsed time? | Excel Discussion (Misc queries) | |||
Linear Mode
