Subtract Timestamps

[learningstatistics]

Hello,

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

2018-03-19 14:34:54 <tbody> </tbody>	2018-03-20 09:34:48 <tbody> </tbody>
2018-03-19 14:50:24 <tbody> </tbody>	2018-03-20 09:34:45 <tbody> </tbody>

<tbody>
</tbody>

If I subtract column 2 from column 1 and format cells to the form yyyy-mm-dd hh:mm:ss , I get

1900-01-00 18:59:54

<tbody>
</tbody>

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