Hello, guys!
I’m having trouble extracting the time from a time column. Please see the attached screenshot.
I used the formula “hour”.
Given that the times in the column are 13:00, 11:50, 15:00, 8:30, and 10:05, I would expect the extracted hours to be 13, 11, 15, 8, and 10. However, I’m seeing unexpected numbers like 21 and 22 instead. Can anyone help me understand why?
Thanks!
The duration column saves a period of time in seconds and displays this period either in format h:mm or h:mm:ss.
Example: When you see the value 1:00 in a duration column, the value stored in SeaTable is 3600. 1hour equals 3600 seconds.
The function hour() is not intended to be used with duration column, but with date-time columns.
What you can do is this: {Hora inicio}/3600. Optionally, you can also round the result to the next hour using round().
Ok, it worked, thanks very much! 
Glad to hear that.
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.
Do it like thousands of other people who have used SeaTable to develop powerful processes and get their ideas and tasks done more efficiently.
