Skip to main content
Solved

ERROR IN DURATION

  • March 10, 2023
  • 1 reply
  • 1 view

Forum|alt.badge.img+1

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!

 

 

Best answer by TheTimeSavingCo

`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 )

 

Link to base

View original
Did this topic help you find an answer to your question?

1 reply

TheTimeSavingCo
Forum|alt.badge.img+28

`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 )

 

Link to base


Reply