Time Calculations in LOBase (SOLVED)

users
#1

Hi all,

I wanted to report back, as I finally got to work this out. I have to
include a lunch break in my calculations, so here is what I did, based on
the examples offered by Bruce and Robert:

SELECT "day_start", "lunch_start", "lunch_end", "day_end", DATEDIFF(
'minute', "day_start", "day_end" ) / 60.00 AS "whole_day", (DATEDIFF(
'minute', "day_start", "day_end" ) - DATEDIFF('minute', "lunch_start",
"lunch_end")) / 60.00 AS "diff_hours" FROM "tTimeEntry"

The result:
*qTotalHours_Example*
day_start lunch_start lunch_end day_end diff_hours
08/15/16 06:30 AM 08/15/16 11:00 AM 08/15/16 12:00 PM 08/15/16 06:00 PM 10.5
08/16/16 06:30 AM 08/16/16 11:00 AM 08/16/16 12:00 PM 08/16/16 03:15 PM 7.75
08/17/16 06:30 AM 08/17/16 11:00 AM 08/17/16 12:00 PM 08/17/16 03:15 PM 7.75
08/18/16 06:30 AM 08/18/16 11:00 AM 08/18/16 12:00 PM 08/18/16 03:15 PM 7.75
08/19/16 06:30 AM 08/19/16 11:00 AM 08/19/16 12:00 PM 08/19/16 03:15 PM 7.75

Or the more "textual" version:
day_start lunch_start
lunch_end day_end diff_hours
08/15/16 06:30 AM 08/15/16 11:00 AM 08/15/16 12:00 PM 08/15/16
06:00 PM 10.5
08/16/16 06:30 AM 08/16/16 11:00 AM 08/16/16 12:00 PM 08/16/16
03:15 PM 7.75
08/17/16 06:30 AM 08/17/16 11:00 AM 08/17/16 12:00 PM 08/17/16
03:15 PM 7.75
08/18/16 06:30 AM 08/18/16 11:00 AM 08/18/16 12:00 PM 08/18/16
03:15 PM 7.75
08/19/16 06:30 AM 08/19/16 11:00 AM 08/19/16 12:00 PM 08/19/16
03:15 PM 7.75

I think I can work out the other calculations I need based on this bit.
Many thanks for the help and examples.

Regards,
Don