Date subtraction with result in seconds and modular division problem

[Ed Harris]

I am trying to subtract a load of dates from an earlier date to end up with seconds which I can then do modular division on with the number of seconds in a sidereal day. This will give me time separation that I can sort to find similar location of points in the celestial sphere. I simply subtracted one of the dates D3 from the earlier date D2 then tried to do the mod division on it and got the same result. I think Iam confused what format these should be in. Or that result is decimal time? Help much appreciated.

Experiment index.xlsx
	D	E	F
2	01/01/2017 00:00
3	20/08/2019 02:29	961.10	961.10
Sheet2

Cell Formulas
Range	Formula
D3	D3	=B3+C3
E3	E3	=D3-D2
F3	F3	=MOD(E3,86164.0935534009)

 

[Norie]

The result in E3 is showing days, not seconds.

If you want the no of seconds between the 2 dates multiple the difference in days by 24 (hrs) by 60 (mins) by 60 (secs).

=(D3-D2)*24*60*60

 

[Ed Harris]

Many thanks, that has solved the problem.