Split Night Shift into Hours per Day

[Miroslav_Tunjic]

Hi all

any ideas how to solve this problem?

can this be doen with the automation or do i need someone to write me script?

night shifts should be split per day, if the time span is over the midnight insert a new row with the working times (Hours) on the next day ... or something like that? 

Thx!

[Zach_Young1]

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

 

[Miroslav_Tunjic · Accepted solution]

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.