Help

Split Night Shift into Hours per Day

Topic Labels: Automations Data Extensions
Solved
Jump to Solution
175 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Miroslav_Tunjic
6 - Interface Innovator
6 - Interface Innovator

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!

 

 

Miroslav_Tunjic_0-1706527083242.png

Screenshot 2024-01-29 121831.jpg

1 Solution

Accepted Solutions

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.

 

 

See Solution in Thread

2 Replies 2
Zach_Young1
4 - Data Explorer
4 - Data Explorer

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:

Screenshot 2024-01-29 at 12.49.26.png

The dates:

Screenshot 2024-01-29 at 12.49.40.png

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.