# Column "Duration" and DateTime Enter method not fitting together

**URL:** <https://community.glideapps.com/t/column-duration-and-datetime-enter-method-not-fitting-together/79475>\
**Category:** Report a Bug\
**Created:** [January 24, 2025, 9:10am UTC](https://community.glideapps.com/t/column-duration-and-datetime-enter-method-not-fitting-together/79475 "2025-01-24T09:10:57Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![\_Romieux](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/_romieux/32/83089_2.png) [@\_Romieux](https://community.glideapps.com/u/_Romieux)\
**Post date:** [January 24, 2025, 9:10am UTC](https://community.glideapps.com/t/column-duration-and-datetime-enter-method-not-fitting-together/79475/1 "2025-01-24T09:10:57Z")

</div>

Hi,  
I have a small issue, Houston! When using GlideTable with the ‘Duration’ column type, how do I input my time? I assume the DataTime enter method is needed, but it allows for selecting the full date instead of just the time. It seems something isn’t configured correctly with this component.

Resume  
Duration column → Only the timer part of the DateTime component is needed, not the full data. No option to set.

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [January 24, 2025, 4:24pm UTC](https://community.glideapps.com/t/column-duration-and-datetime-enter-method-not-fitting-together/79475/2 "2025-01-24T16:24:02Z")

</div>

I don’t know if this helps:

> **[Format Duration | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/format-duration)**
>
> Format a duration from seconds into hh:mm:ss.

---

<div class="post-metadata">

**Author:** ![\_Romieux](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/_romieux/32/83089_2.png) [@\_Romieux](https://community.glideapps.com/u/_Romieux)\
**Post date:** [January 24, 2025, 4:54pm UTC](https://community.glideapps.com/t/column-duration-and-datetime-enter-method-not-fitting-together/79475/3 "2025-01-24T16:54:46Z")

</div>

OK, but what about the special Simple Column named “Duration” how to use from a entry form.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 24, 2025, 5:02pm UTC](https://community.glideapps.com/t/column-duration-and-datetime-enter-method-not-fitting-together/79475/4 "2025-01-24T17:02:54Z")

</div>

If you enter a value in days, it will convert to a duration.

1 days = 24:00:00  
1.5 days = 36:00:00  
1.0001 days = 24:00:09

Date math in a math column that subtracts one date from another will always calculate the difference in days or a decimal fraction of days.

So anything to the left of the decimal is whole days and anything to the right of the decimal is fractional days. Populating the column can happen a variety of ways, but it’s only useful if you need it to convert a number into a formatted duration.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [July 23, 2025, 5:03pm UTC](https://community.glideapps.com/t/column-duration-and-datetime-enter-method-not-fitting-together/79475/5 "2025-07-23T17:03:25Z")

</div>

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