# Having trouble extracting the "hour" from the time

**URL:** <https://forum.seatable.com/t/having-trouble-extracting-the-hour-from-the-time/6856>\
**Category:** Formulas\
**Tags:** formula\
**Created:** [July 29, 2025, 3:01pm UTC](https://forum.seatable.com/t/having-trouble-extracting-the-hour-from-the-time/6856 "2025-07-29T15:01:41Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![adriana.lfz](https://forum.seatable.com/letter_avatar_proxy/v4/letter/a/258eb7/32.png) [@adriana.lfz](https://forum.seatable.com/u/adriana.lfz)\
**Post date:** [July 29, 2025, 3:01pm UTC](https://forum.seatable.com/t/having-trouble-extracting-the-hour-from-the-time/6856/1 "2025-07-29T15:01:41Z")

</div>

Hello, guys!

I’m having trouble extracting the time from a time column. Please see the attached screenshot.

 ![image](https://forum.seatable.com/uploads/default/original/2X/3/3741eff680c5786ac32aaa52e83e330175e40d77.png)

 ![image](https://forum.seatable.com/uploads/default/original/2X/e/ef28bb895b7c53a30f799a7321d7f0db65f53fd3.png)

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!

---

<div class="post-metadata">

**Author:** ![rdb](https://forum.seatable.com/user_avatar/forum.seatable.com/rdb/32/1869_2.png) [@rdb](https://forum.seatable.com/u/rdb)\
**Post date:** [July 29, 2025, 3:10pm UTC](https://forum.seatable.com/t/having-trouble-extracting-the-hour-from-the-time/6856/2 "2025-07-29T15:10:34Z")

</div>

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().

---

<div class="post-metadata">

**Author:** ![adriana.lfz](https://forum.seatable.com/letter_avatar_proxy/v4/letter/a/258eb7/32.png) [@adriana.lfz](https://forum.seatable.com/u/adriana.lfz)\
**Post date:** [July 29, 2025, 3:18pm UTC](https://forum.seatable.com/t/having-trouble-extracting-the-hour-from-the-time/6856/3 "2025-07-29T15:18:23Z")

</div>

Ok, it worked, thanks very much! ☺

---

<div class="post-metadata">

**Author:** ![rdb](https://forum.seatable.com/user_avatar/forum.seatable.com/rdb/32/1869_2.png) [@rdb](https://forum.seatable.com/u/rdb)\
**Post date:** [July 29, 2025, 4:22pm UTC](https://forum.seatable.com/t/having-trouble-extracting-the-hour-from-the-time/6856/4 "2025-07-29T16:22:20Z")

</div>

Glad to hear that.

---

<div class="post-metadata">

**Author:** ![system](https://forum.seatable.com/uploads/default/original/1X/04603423fe81a46c321283663086c475429e8ccb.png) [@system](https://forum.seatable.com/u/system)\
**Post date:** [July 31, 2025, 4:22pm UTC](https://forum.seatable.com/t/having-trouble-extracting-the-hour-from-the-time/6856/5 "2025-07-31T16:22:58Z")

</div>

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.