How to use date functions in LibreOffice calc

[@andre.79]

Awesome! Thanks a lot!

[@libreofficetutorials9499]

No worries!

[@ITsEasyExcel]

Love it

[@libreofficetutorials9499]

thanks

[@grannysaxton9568]

Nice and easy

[@libreofficetutorials9499]

Thanks a lot 😊

[@ITsEasyTraining1st]

Super cool

[@libreofficetutorials9499]

thanks

[@christopherlyons7613]

I have date/time values that I want to add a number of minutes & seconds to and get the resulting date/time value. Is there a date function that would allow you to do this? For example, I have a starting date/time value of "04/08/2024 14:53:11" and I need to add a min:sec duration of "12:58". I need the result formatted as a date/time value. How can I do this?

[@libreofficetutorials9499]

Yes you can, format the date time as date time use ctrl +1 to get into format cells. then format the second cell as time. Add the two together it will work and add the time on to the first date and time cell.

[@mrfudd13]

Is there a function which gives a DATE, a number of DAYS after a start DATE?

[@libreofficetutorials9499]

Use the days function

[@mrfudd13]

@@libreofficetutorials9499 Actually, I was overthinking it: all you have to do is put a date in, it can be "3/5/24" or "March 5" and then add "+ n", and Calc. will figure it out: no function needed.

[@ITX-EcoClass]

I can't seem to get the =MONTH() function to properly copy to my other cells. It's fine if I enter it manually, but I can't drag it down the row and have it give an accurate sum, it only shows the result of the cell that was copied. Annoying, but thank you for this video, because unless you're comfortable with coded language speak then the help manual is really... useless. EDIT: And I figured it out - my cells were formatted as DATE, when they should've been set to General.

[@Albertbullterrier]

Sometimes these things are sent to try us. It should copy down, probably a bug

[@libreofficetutorials9499]

It should pull down, try reloadedor updating

[@EasyMSAccess]

love it

[@libreofficetutorials9499]

thanks

[@EasyMicrosoftWord]

Love it

[@libreofficetutorials9499]

thanks