How to handle reports with complicated time requirements

Today we made a night watch report for a boat club. The club is using the Blippa system to record all events (checkin/checkout, controlled checkpoints, notes etc).

All data is stored in a Blippa data source that can be viewed in a Blippa page.

But, in this case, the club also wanted a daily email with a report spreadsheet attached.
So, we used a Worker (DataSource Report).
The trick was to make the report span over the night…
Normally you can select a 24 hour day, but how to select events from 7PM to 7AM???

The solution was to make our variables more capable:
(Tidpunkt is Swedish for time)