User Day wise Timezone Issue

Took me a bit to determine this one, but I was trying to "balance" worklog data from another tool (Pivot Reports) as they didn't match what is shown in this extension. If you look at the image I provided, the horizontal totals match the cumulative total (57h 30m), however the vertical totals actually total something different (63h 30m). The 63h 30m is what pivot reports was reporting, so I was research "why". In that I noticed the two lines (square rectangle in image) don't show any hours, yet show a total in the vertical totals. These both were entered at 10:19 PM PST which translates to 1:19 AM EST which is outside the range of the report (these 2 entries were made the "end date" of the report.

It would seem the worklog query and the total query are using different forms of timezone comparison.

Hope this helps you find the bug....

2019-04-24 14_31_01-Window