[libreoffice-users] Time Calculations in LOBase

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+unsubscribe@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