Skip to main content

mastodon - Link to source
Handy #LibreOffice Calc tip! Press Ctrl+; to insert the current date, or Shift+Ctrl+; for the current time. Want a date and time that's always updating? Use the =NOW() function. help.libreoffice.org/latest/en… #foss #opensource
Screenshot of Calc

Date & Time Functions

help.libreoffice.org
#foss #opensource #libreoffice

reshared this

in reply to LibreOffice

Leeloo
mastodon - Link to source
Leeloo
• •
I wonder how that works on European keyboards where typing ; needs shift.
in reply to LibreOffice

Mars 1024 🎄🎁
mastodon - Link to source
Mars 1024 🎄🎁
• •

: but wouldn't the time change the next time the workbook is opened/refreshed?

Need static data, not dynamic data...

in reply to Mars 1024 🎄🎁

Leeloo
mastodon - Link to source
Leeloo
• •

@mars1024 If I'm reading it correctly, the keypresses insert a static date / time, the function is dynamic.

So you should ba able to subtract them and show "this document is x days old".

@Mars 1024 🎄🎁
⇧