Remove the time component

Date > Remove time component

This tool allows you to effectively remove the time components from dates in the selected cells Excel (Calc) . Leaving only part with the date, this utility helps to clean and standardize data sets, making them more suitable for analysis, reporting or formatting.

Use the tool to convert dates to different formats Turning/recognition of dates .

Screen shot

After application:

Starting this tool

Click YLC Utilities > Date > Remove time component :

Excel:

LibreOffice Calc:

How much time will it save?

Using this tool, you are guaranteed to save time and effort. However, actual time savings depends on how often you use Excel (Calc) , the amount of data you work with and how often you use this tool.

Download extensions

You can use the utility Remove time component by installing the extension YLC Utilities .

This feature will be available in all files that will be opened in Excel (LibreOffice Calc).