Hi
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 ...
Hi Jonathan
Thanks for your prompt response.
The times are duration fields, i thought this the correct type to use.
I already have a date field.
Should I use something like an And statement to concatenate the date and time then evaluate duration.
or
...
