# TIME FORMAT is wrong

**URL:** <https://community.glideapps.com/t/time-format-is-wrong/74160>\
**Category:** Ask for Help\
**Created:** [June 15, 2024, 11:38am UTC](https://community.glideapps.com/t/time-format-is-wrong/74160 "2024-06-15T11:38:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kemal1973](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kemal1973/32/72721_2.png) [@Kemal1973](https://community.glideapps.com/u/Kemal1973)\
**Post date:** [June 15, 2024, 11:38am UTC](https://community.glideapps.com/t/time-format-is-wrong/74160/1 "2024-06-15T11:38:13Z")

</div>

I have a column named "time remaining (hour) in my table but when it is less than one hour it doesn’t display “hh” and only shows mm:ss

 ![Inkedtime remaining(hour)_LI](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/7/4746e6602e15d272ea4cccc0d2eb25f620bc9c90.jpeg)

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [June 15, 2024, 2:30pm UTC](https://community.glideapps.com/t/time-format-is-wrong/74160/2 "2024-06-15T14:30:17Z")

</div>

Because of your calculation method, it will be a duration instead of a date-time.

> [@date Guide: Mastering Dates & Times](https://community.glideapps.com/t/guide-mastering-dates-times/70381):
>
> The Date & Time column contains both a date and time value within one single value. Dates and times can therefore be tricky to understand and to work with. It helps to keep things simple to stay out of trouble. Here are a few tips: Writing dates Avoid writing dates manually. Use a picker instead. If done via import, be weary of the format of the date column in the source. Relations Anytime you create a relation with a date, convert the date to either a string (template column) or a number (…