Help

ERROR IN DURATION

Solved
Jump to Solution
575 1
cancel
Showing results for 
Search instead for 
Did you mean: 
ROYESPINALD
4 - Data Explorer
4 - Data Explorer

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!

 

at1.jpg

AT2.jpg

AT3.jpg

 

1 Solution

Accepted Solutions
TheTimeSavingCo
16 - Uranus
16 - Uranus

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

 

Screenshot 2023-03-10 at 4.28.26 PM.png

Link to base

See Solution in Thread

1 Reply 1
TheTimeSavingCo
16 - Uranus
16 - Uranus

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

 

Screenshot 2023-03-10 at 4.28.26 PM.png

Link to base