It occurs to me my OP may not have been as clear as it should be. To clarify, I need to calculate the decimal value of the times involved: (([day_end]-[day_start])-([lunch_end]-[lunch_start])) = H.nn worked
So, for example: ((17:00-08:00)-(13:00-12:00)) = 8.0 I don't believe the DATEDIFF function gives me what I am looking for, but maybe it can with some extra work. I was pretty sure I would find some examples of this type of calculation out there. On Thu, Aug 25, 2016 at 11:54 AM, Don Parris <parri...@gmail.com> wrote: > 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 > -- 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