Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 15 Jun 2018 12:10:19 +0200DateDiff between records on same tablehttps://ask.libreoffice.org/en/question/158081/datediff-between-records-on-same-table/Hi, I have a Base DB at work (HSQ) which has a table populated with thousands of records, one of the fields is a Date field. I need to find some way of querying the difference between each successive record, so “DateDiff” I guess. But how can I compare between record 1 and 2, then 2 and 3 etc etc.ZoarskFri, 15 Jun 2018 12:10:19 +0200https://ask.libreoffice.org/en/question/158081/Calc - Total Number of Days + Hrs in Date Rangehttps://ask.libreoffice.org/en/question/26749/calc-total-number-of-days-hrs-in-date-range/Hi
I am attempting to make a spreadsheet to calculate the total number of days + hours passed between a date range. To do this, I have a multiple colomns.
1. Opening Date
2. Closing Date
3. Opening Hour
4. Closing Hour
Is there a way for me to calculate Total Days and Total Hours based on the aforementioned columns.
When I tried the =datediff with the formula `=datediff(o2,p2,d)` i get a #NAME? error, where O2 is the cell for Opening Date and P2 is the cell for Closing Date.
No idea how to calculate the total number of hours if the number of hours exceeds over 24 hours, which it does in this case.
Help :)spacemonkeyTue, 03 Dec 2013 14:40:08 +0100https://ask.libreoffice.org/en/question/26749/