how do I paste in a time so that it is not formatted as text

edit

Hello,

using Right click -> Paste Special ... -> Unformatted Text should do the job, though Unformatted Text sounds a bit counter-intuitive, since you want it as a number and not text. But telling LibreOffice to paste unformatted text makes the number recognition fully active, while not doing so may paste format information as well (and hence turns to text)

To change the format (if already entered and having a ' in front of the time) perform:

• Select the times (or dates)
• Data -> Text to Columns...
• Click OK (without making any settings)

Note: This procedure only works that way, if a ' automatically appeared after having entered the time or date. The '-character indicates that LibreOffice "knows" the data could be a number as well.

Hope that helps.

Hi, you have to change/edit the cells Format for this.

1. Select the Cells (or Columns) where you want to place the timestamps
2. Right Click into the Selection and in the Submenu select Format Cells ... or via the Menu: Format > Cells ...

Here you can set/describe the way your cells should be formated.

See: Category > Time

Hope it helps.