Hi all, I need to do some time calculations in LO Base queries - seems fairly straightfoward, but I can't seem to find any good info on how this is done.
I am calculating hours worked in a day (could span midnight, but that is not normally the case). In a certain app similar to Base, I can do: (([day_end]-[day_start])-([lunch_end]-[lunch_start])) In LO Base, the query fails on a wrong data type failure. I am using the Date/Time data type (time stamp). Can anyone point me to good information on how to perform this calculation in Base? Many thanks in advance! Don -- D.C. Parris, FMP, Linux+, ESL Certificate Minister, Security/FM Coordinator, Free Software Advocate http://dcparris.net/ <https://www.xing.com/profile/Don_Parris> <http://www.linkedin.com/in/dcparris> GPG Key ID: F5E179BE -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
