[libreoffice-users] Re: Time Calculations in LOBase

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