I have a work start date, I know how long the work is going to take (in hours) and I want to calculate an estimated End date. But different days of the week has different shift hours fx. Mon-Thurs has 10 hours shifts, Friday 9 hours and Saturday 5 hours.
Is it possible to calculate an end date, with these informations?
Yes I ended up doing a java script and a button, just thought there might have been a simple way using the Airtable script, which I couldn’t see. But stopped after I slipped further and further into the if-statement rabbit hole.