Enter Current Date and Time in LibreOffice Calc

This guide explains how you can enter the current date and time in the LibreOffice Calc worksheet.

And it’s very easy.

Enter Current Date

You can use TODAY() function to enter today’s date. This function doesn’t take any argument. You can enter it to any cell to show the current date.

Today function
Today function

Remember, whenever you open the Calc spreadsheet, the date is updated with the current date.

Enter Current Time

To enter the current time, use the NOW() and TODAY() function both. Like the TODAY() function, NOW() also updates whenever the Calc sheet is recalculated. LibreOffice Calc sheet is recalculated almost every time you perform any activity – typing, saving, opening, etc. If you want to manually update, press F9.

If you enter only NOW() it will give you the date and time together. The date format should be based on LibreOffice profile, country – language settings. Same for the time as well.

SEE ALSO:  Calc Spreadsheet Err 502 - How to Solve
Now Function
Now Function

To get the current time, use NOW() - TODAY() as a formaula as below.

Current time before formatting
Current time before formatting

But as you can see it is a decimal number. Because LibreOffice Calc represents time as a number between 0 and 1. To convert it to a time you have to apply a time format. Learn more about formatting cells.

Current time after formatting
Current time after formatting

Static Date and Time with Keyboard Shortcut

To enter a current date as a static date, press CTRL+; (semicolon). It will insert today’s date as a static value in the corresponding cell.

Similarly to enter current time as staic value, press CTRL+SHIFT+;.

To enter current date and time both as a static value, from keyboard press CTRL+; then press enter; Press F2 to edit the cell, then give a space and press CTRL+SHIFT+;

I hope this guide helped you to understand the current date and time including its static value in the LibreOffice Calc sheet.


Looking for something else?

Read our complete tutorial index of Calc, Writer, Impress and Draw.


Join our Telegram channel and stay informed on the move.

Related


arindam

IT professional by profession and founder of libreofficehelp.com. Loving Linux and other technologies since 2002. I believe in open source and its philosophy. Follow me on Twitter or email me.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.