# Convert to Time Value

**URL:** <https://community.glideapps.com/t/convert-to-time-value/62394>\
**Category:** Ask for Help\
**Created:** [June 2, 2023, 4:09pm UTC](https://community.glideapps.com/t/convert-to-time-value/62394 "2023-06-02T16:09:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![T\_Cha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/t_cha/32/59227_2.png) [@T\_Cha](https://community.glideapps.com/u/T_Cha)\
**Post date:** [June 2, 2023, 4:09pm UTC](https://community.glideapps.com/t/convert-to-time-value/62394/1 "2023-06-02T16:09:10Z")

</div>

Hi,

I watched Mr.Robert convert time to time value so that I can manage open or close time.  
https://www.youtube.com/embed/SanIVHgCjUE?feature=oembed&wmode=opaque&list=PLiXRc87c6KKVRfliL2oEji-k30ugP_Q5Q

I put 9.00 which the time I would like to open and I chose dateandtime column but time did not show. So I changed to number column, it shown 9.00 but I cannot do math with.

This is short video clip.

> **[video1294711976.mp4](https://drive.google.com/file/d/1hJNOJikcyvPtVYqM4k6_p6pxBUyLlC9S/view?usp=sharing)**
>
> Google Drive file.

It’s showing me weird date

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/0/f02ba7e66d34b043695956b428e28f216e704d95.jpeg)

Put the number, it was there. But once I click enter my number was gone.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/e/be2f9c5c0c10073359d263bd74a1dae19651f086.jpeg)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/c/3c934dac475bd59e17db38cd44789c805484bfb9.jpeg)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 3, 2023, 12:32am UTC](https://community.glideapps.com/t/convert-to-time-value/62394/2 "2023-06-03T00:32:27Z")

</div>

What exactly is your desired outcome? Have you tried using “0.375” instead?

0.375 corresponds to 9/24 (9AM/24 hours). Say you want 12PM then it would be 0.5 (12PM/24 hours).

Please also make sure you choose Parts \> Time only.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/0/20098be0fd48e013f68c358394f9a405e7c44128.png)

---

<div class="post-metadata">

**Author:** ![T\_Cha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/t_cha/32/59227_2.png) [@T\_Cha](https://community.glideapps.com/u/T_Cha)\
**Post date:** [June 3, 2023, 1:16pm UTC](https://community.glideapps.com/t/convert-to-time-value/62394/3 "2023-06-03T13:16:34Z")

</div>

Thank you so much. I was just put 09.00 directly, I have no idea I have to put 0.375 instead (9/24)

I’ve come this far because of watching a lot of YouTube, specially Mr. Robert’s videoes and all of the help of this community.

🥰

---

<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:** [June 4, 2023, 1:17pm UTC](https://community.glideapps.com/t/convert-to-time-value/62394/4 "2023-06-04T13:17:08Z")

</div>

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