Get date difference in seconds

[Clamarc]

Hi,

My Excel is Prefessional plus 2016

How do I get the difference between two dates in seconds?
date1: 2024-06-21 11:20:35.740
data2: 2024-06-21 10:58:51.110

Note: dates are in the format yyyy/mm/dd hh:mm:ss,000

Thank's

 

[Cubist]

It depends on the mechanism of how your log is being generated. There might be an efficient way to do it. A brute force way is to treat it as a string and extract the date/time components like this. The formula looks long but it's just doing the same thing twice. With a newer version of Excel (365), the formula can be shortened substantially.

Book1
	B	C	D
3	2024-06-21 11:20:35.740	2024-06-21 10:58:51.110	1304.630
Sheet3

Cell Formulas
Range	Formula
D3	D3	=86400*(SUM(--LEFT(B3,FIND(" ",B3)),TIMEVALUE(MID(B3,FIND(" ",B3),LEN(B3))))-SUM(--LEFT(C3,FIND(" ",C3)),TIMEVALUE(MID(C3,FIND(" ",C3),LEN(C3)))))