# Time picker **URL:** \ **Category:** Feature Requests\ **Created:** [October 1, 2019, 1:58pm UTC](https://community.glideapps.com/t/time-picker/774 "2019-10-01T13:58:51Z")\ **Posts on this page:** 18\ **Page:** 2
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 2, 2021, 11:09am UTC](https://community.glideapps.com/t/time-picker/774/21 "2021-03-02T11:09:15Z")
Use 12/30/1899 as a 0 am and display only time, 12/31/ 1899 would be 24 hours and if you convert 12/31/1899 to a number. it will give you 1, now just divide by 24 for hours. than again by 60 for minutes and again by 60 for seconds… add result to a current DATE() and you have time for calculations if business is open now ---
**Author:** ![Mishta\_P](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mishta_p/32/16900_2.png) [@Mishta\_P](https://community.glideapps.com/u/Mishta_P)\ **Post date:** [March 2, 2021, 12:39pm UTC](https://community.glideapps.com/t/time-picker/774/22 "2021-03-02T12:39:56Z")
Example use for time picker. ![Screenshot 2021-03-02 12.37.17](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/6/26f15e085ad201f12412eafa8037634da9f76193.png) ---
**Author:** ![Gary\_Biagioni](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_biagioni/32/4201_2.png) [@Gary\_Biagioni](https://community.glideapps.com/u/Gary_Biagioni)\ **Post date:** [March 6, 2021, 1:52pm UTC](https://community.glideapps.com/t/time-picker/774/23 "2021-03-06T13:52:49Z")
I know this does not quite fit as this is mostly about time of days but I would like an hours minutes seconds picker. The use case is for time entries from say a race. I would like the seconds to be specifiable to the number of decimal places. ---
**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:** [March 6, 2021, 3:17pm UTC](https://community.glideapps.com/t/time-picker/774/24 "2021-03-06T15:17:07Z")
You could create 3 choice components. One each for Hours, Minutes, and Seconds. The user can select from all three and you can write the decimal equivalent into the sheet. All you need is a sheet with 60 rows to list all hours/minutes/seconds in three columns and their corresponding decimal value in three more columns. ---
**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:** [March 6, 2021, 3:27pm UTC](https://community.glideapps.com/t/time-picker/774/25 "2021-03-06T15:27:04Z")
> [@Mishta\_P](#): > > ie 10:15 is 10.25. Any idea how to convert it back to time again You could probably do something like this in a math column ```auto TRUNC(Time) + 60*(Time-TRUNC(Time))/100 ``` Then you will probably need a template column to replace the decimal point with a ‘:’. Otherwise you can break the math out (and exclude the divide by 100) into two columns to get 10 in one column and 15 in another column, then use a template column to join the two values together with ‘:’. ---
**Author:** ![Gary\_Biagioni](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_biagioni/32/4201_2.png) [@Gary\_Biagioni](https://community.glideapps.com/u/Gary_Biagioni)\ **Post date:** [March 6, 2021, 5:29pm UTC](https://community.glideapps.com/t/time-picker/774/26 "2021-03-06T17:29:02Z")
Did this for hours minutes seconds and the tenths as well. So no issues. Would really like a slick editor like the date time though. BTW the one user I tried it on liked it better than typing ---
**Author:** ![Gary\_Biagioni](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_biagioni/32/4201_2.png) [@Gary\_Biagioni](https://community.glideapps.com/u/Gary_Biagioni)\ **Post date:** [March 6, 2021, 5:29pm UTC](https://community.glideapps.com/t/time-picker/774/27 "2021-03-06T17:29:35Z")
My app is a little different but that is essentially what i did ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 11, 2021, 7:04pm UTC](https://community.glideapps.com/t/time-picker/774/28 "2021-03-11T19:04:37Z")
to make it easy, i created a time picker: > **[Time & Address Picker](https://sa-test.glideapp.io/)** > > pick the time using buttons & enter address or place name, and this App will find the proper address and geolocation ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 2, 2021, 8:19pm UTC](https://community.glideapps.com/t/time-picker/774/29 "2021-05-02T20:19:34Z")
adjust business open hours and check if is open now (click image to open this App) [![Screen Shot 2021-05-02 at 4.39.49 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/4/64009c058ece048ca3159b7e43ca0623d9ddc736.png)](https://sa-test.glideapp.io/)[![Screen Shot 2021-05-02 at 4.17.31 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/d/3deccbda23e2d0cf1e0d9590686e1901d27c11bc.png)`](https://sa-test.glideapp.io/) . ---
**Author:** ![Share](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@Share](https://community.glideapps.com/u/Share)\ **Post date:** [July 2, 2021, 5:40am UTC](https://community.glideapps.com/t/time-picker/774/30 "2021-07-02T05:40:57Z")
Your time-picker is exactly what I need. How do I incorporate it in my app? (I am a beginner) Thanks. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [July 2, 2021, 7:00am UTC](https://community.glideapps.com/t/time-picker/774/31 "2021-07-02T07:00:42Z")
it is a quite complex app, probably day or two work for an expert ---
**Author:** ![Share](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@Share](https://community.glideapps.com/u/Share)\ **Post date:** [July 2, 2021, 8:08am UTC](https://community.glideapps.com/t/time-picker/774/32 "2021-07-02T08:08:49Z")
Thanks Uzo. i’ll resort to using Date+Time picker and then deleting the date. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [July 2, 2021, 8:11am UTC](https://community.glideapps.com/t/time-picker/774/33 "2021-07-02T08:11:01Z")
from my experience, that would not give you good results… best way is to create your own time format and have formula to translate it to universal Glide or Google format for other purposes ---
**Author:** ![mbnownet](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mbnownet/32/37355_2.png) [@mbnownet](https://community.glideapps.com/u/mbnownet)\ **Post date:** [July 19, 2022, 1:42am UTC](https://community.glideapps.com/t/time-picker/774/34 "2022-07-19T01:42:11Z")
how do i upvote this? ---
**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:** [July 19, 2022, 2:18am UTC](https://community.glideapps.com/t/time-picker/774/35 "2022-07-19T02:18:20Z")
Click on the vote button on the original post at the top. ---
**Author:** ![mbnownet](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mbnownet/32/37355_2.png) [@mbnownet](https://community.glideapps.com/u/mbnownet)\ **Post date:** [July 20, 2022, 1:40pm UTC](https://community.glideapps.com/t/time-picker/774/36 "2022-07-20T13:40:55Z")
derp. I was looking for it on the same row as Reply. I’m sure I saw it somewhere else in other posts. ---
**Author:** ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)\ **Post date:** [September 3, 2022, 10:35am UTC](https://community.glideapps.com/t/time-picker/774/37 "2022-09-03T10:35:33Z")
I would also love to see this implemented … I see we have the option to create a column based on time only, but there isn’t a field that can select only the time so no exact match for that column ---
**Author:** ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)\ **Post date:** [September 3, 2022, 10:47am UTC](https://community.glideapps.com/t/time-picker/774/38 "2022-09-03T10:47:05Z")
My approach would be something like this - when a date & time column has only time selected the component date should display only the time and store it in that column … also , it should be renamed to Date and Time [Previous page](https://community.glideapps.com/t/time-picker/774.md?page=1)