Hi,
We have been using Airtable for a while to collect real time data from commercial units where our field agents checks the stock available.
This is how it looks like:
Date / Product / Commercial Unit …
Each report has a deadline.
For example:
in...
Hi,
I try to calculate the time duration between two date fields with DATETIME_DIFF formula, but doesn’t work at all. It shows totally false results.
Here it is:
This is the formula I use:
This is the formatting for duration:
Any idea what I shoul...
Hi there,
Thanks for your responses!
The solutions was.
One time field was in GMT while the other wasn’t. So I turned off this setting on both.
Furthermore the formula has been set to Duration and h:mm:ss format.
Now it works.
