Subtract Timestamps

[learningstatistics]

Hello,

I am wondering how you can subtract timestamps looking something like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 129"]
<tbody>[TR]
[TD="width: 129"]2018-03-19 14:34:54[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 128"]
<tbody>[TR]
[TD="width: 128"]2018-03-20 09:34:48[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 129"]
<tbody>[TR]
[TD="width: 129"]2018-03-19 14:50:24[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 128"]
<tbody>[TR]
[TD="width: 128"]2018-03-20 09:34:45[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]


If I subtract column 2 from column 1 and format cells to the form yyyy-mm-dd hh:mm:ss , I get [TABLE="width: 143"]
<tbody>[TR]
[TD="class: xl65, width: 143, align: right"]1900-01-00 18:59:54[/TD]
[/TR]
</tbody>[/TABLE]

which does not make sense.

Thank you

 

[mole999]

format for [h]:mm:ss if you are using 1904 date system then you can get the right visual otherwise ########## will be the result