The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.
I'm new with these and I think i'm having a big mistake but I cannot find it.
I'm trying to extract the number of hours for an specific duration record.
Obviously I use HOUR command but it doesn't work!
As you can see in screenshots, the field Hours works in the following way:
Hour({Time})
But, it generates ERROR!
What am I doing wrong?
Thanks!
Accepted Solutions
`HOUR()` expects a date time, not a duration and that's why you're getting the error.
To get the hour, try either of the following:
ROUNDUP(
Duration / 60 / 60,
1
)
ROUNDDOWN(
Duration / 60 / 60,
1
)
`HOUR()` expects a date time, not a duration and that's why you're getting the error.
To get the hour, try either of the following:
ROUNDUP(
Duration / 60 / 60,
1
)
ROUNDDOWN(
Duration / 60 / 60,
1
)
