New to Airtable ‘today’, trying to convert my elaborate spreadsheet into a database.
I am struggling with a duration calculation.
Works fine if you start at 12:00 and finish at 23:00, I hit the wall when the finish time is 01:00 or later the next day.
I can create an if statement that is if end is greater than start end-start. if not true i can ask it to midnight takeaway start + end. It’s the formatting the midnight time to subtract the start time causing me an issue.
If there is there a better solution out there ??
Thanks in advance