# How to create, just, the time picker

**URL:** https://community.glideapps.com/t/how-to-create-just-the-time-picker/32072
**Category:** Ask for Help
**Created:** [September 21, 2021, 12:12am UTC](https://community.glideapps.com/t/how-to-create-just-the-time-picker/32072 "2021-09-21T00:12:06Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![LastSpy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lastspy/32/32100_2.png) [@LastSpy](https://community.glideapps.com/u/LastSpy)
#### Post date: [September 21, 2021, 12:12am UTC](https://community.glideapps.com/t/how-to-create-just-the-time-picker/32072/1 "2021-09-21T00:12:07Z")

</div>

I want to make survey on one of my pages and google sheets is summing the all times from one person. The problem is that when someone submits a new flyer over time, it is not counted in google sheets because the [’] sign appears next to the time.

How can I fix it so that only the time is sent, without the date or other signs?

---

<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: [September 21, 2021, 12:14am UTC](https://community.glideapps.com/t/how-to-create-just-the-time-picker/32072/2 "2021-09-21T00:14:34Z")

</div>

> [@LastSpy](#):
>
> google sheets is summing the all times from one person

Can you go into more details about what is being summed here? Are you trying to calculate the total amount of time people do the survey?

---

<div class="post-metadata">

### Author: ![LastSpy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lastspy/32/32100_2.png) [@LastSpy](https://community.glideapps.com/u/LastSpy)
#### Post date: [September 21, 2021, 12:18am UTC](https://community.glideapps.com/t/how-to-create-just-the-time-picker/32072/3 "2021-09-21T00:18:55Z")

</div>

No. each person can create several pages and each page can show a different time. This google sheets counts and summarizes for each person.

---

<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: [September 21, 2021, 12:39am UTC](https://community.glideapps.com/t/how-to-create-just-the-time-picker/32072/4 "2021-09-21T00:39:34Z")

</div>

Can you send over some screenshots? What does your flow count and summarize exactly? Sounds like you are trying to sum a date/time variable?

---

<div class="post-metadata">

### Author: ![LastSpy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lastspy/32/32100_2.png) [@LastSpy](https://community.glideapps.com/u/LastSpy)
#### Post date: [September 21, 2021, 12:30pm UTC](https://community.glideapps.com/t/how-to-create-just-the-time-picker/32072/5 "2021-09-21T12:30:56Z")

</div>

![opera_fR4W6aD9AN](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/2/d2dda85c8136b78b5d93ff395890f6fc769616ef.png)  
As you can see here. only time is counted here.

But it does not count the time if it is written differently, for example, ['01: 00: 00]; [21.09.2021T01: 00: 00Z] and others.

---

<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: [September 21, 2021, 12:45pm UTC](https://community.glideapps.com/t/how-to-create-just-the-time-picker/32072/6 "2021-09-21T12:45:39Z")

</div>

There’s no way to write time only using the date picker or date time picker, but you can convert it in Sheets using the Hour, Minute, Second formulas.

However, if you can, please share more about your use case so we can help you do this in Glide, if you don’t need this in the Sheets.