It seems like if someone creates one record for a shift that spans two days, you want to create a new record for the second day with just the hours for the second day (and also edit the original record to only include hours for day 1?).
What about letting the shift be its own atomic thing, and then summing up the hours of all shifts on dates (in a differen table)?
The shifts:

The dates:

The hours on the dates sum correctly.
https://airtable.com/appJb2u1Myw9JqubZ/shr45zUnzX86H7wqi
It seems like if someone creates one record for a shift that spans two days, you want to create a new record for the second day with just the hours for the second day (and also edit the original record to only include hours for day 1?).
What about letting the shift be its own atomic thing, and then summing up the hours of all shifts on dates (in a differen table)?
The shifts:

The dates:

The hours on the dates sum correctly.
https://airtable.com/appJb2u1Myw9JqubZ/shr45zUnzX86H7wqi
Hi Zach
Thx!
it is legal obligation (for hourly workers, in Austria) to split the days, when worked over the midnight.
i figured it out
its the automation that finds the record, updates the time fields and creates new record for the next day.