LibreOffice Calc - Dates and Time

How to use Date and Time functions. Finding the number of days between two dates, finding the last date of any month. Make a time clock, or calculate the elapsed time between 2 events.
Spreadsheet files used in the video are available at panopia.com/libreoffice/

[@MrCosmos110]

Excellent ! ! !
KIS "Keep It Simple"

[@TankdozerCavalry]

Hey, pretty good video. Thanks!
One question, though: How are timezones handled?

[@tunca3032]

Thank you

[@criconinvestments7723]

I just need to know how to format cells in a column for time. When I type in 10 it says 12am

[@LainK1978]

I was hoping that this would have a way to determine the elapsed time from a date time over multiple days 01/03/2020 20:23:53 12/31/2019 05:25:32

[@chasone4431]

He has another video for that ;-)

[@clintonreisig]

There must be an easier way