# Quiero obtener las horas entre 2 variables que son de tipo template, pero que tienen como valor fecha

**URL:** <https://community.glideapps.com/t/quiero-obtener-las-horas-entre-2-variables-que-son-de-tipo-template-pero-que-tienen-como-valor-fecha/86529>\
**Category:** Ask for Help\
**Created:** [March 2, 2026, 12:10am UTC](https://community.glideapps.com/t/quiero-obtener-las-horas-entre-2-variables-que-son-de-tipo-template-pero-que-tienen-como-valor-fecha/86529 "2026-03-02T00:10:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Katherin\_Rojas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katherin_rojas/32/94403_2.png) [@Katherin\_Rojas](https://community.glideapps.com/u/Katherin_Rojas)\
**Post date:** [March 2, 2026, 12:10am UTC](https://community.glideapps.com/t/quiero-obtener-las-horas-entre-2-variables-que-son-de-tipo-template-pero-que-tienen-como-valor-fecha/86529/1 "2026-03-02T00:10:21Z")

</div>

Alguien me puede orientar como hacer esto en glide? he intentado hacerlo, creando una nueva columna de tipo date difference pero no me convierte en houras reales. Esta resta se deberia lograr con los campos ‘FechaHoraActual’ y ‘FechaHora\_Reserva’ pero no doy con ello, ya que lo necesito para enviar este dato a otro campo que sirve como if then else e indicarle si debe liberar el cupo o no

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

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 2, 2026, 2:13am UTC](https://community.glideapps.com/t/quiero-obtener-las-horas-entre-2-variables-que-son-de-tipo-template-pero-que-tienen-como-valor-fecha/86529/2 "2026-03-02T02:13:40Z")

</div>

Use a Text to Date column to convert the Templates to datetime, then you can use standard date math to determine the difference.

Why are you using templates to represent dates and times instead of datetime columns?

---

<div class="post-metadata">

**Author:** ![Katherin\_Rojas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katherin_rojas/32/94403_2.png) [@Katherin\_Rojas](https://community.glideapps.com/u/Katherin_Rojas)\
**Post date:** [March 2, 2026, 2:28am UTC](https://community.glideapps.com/t/quiero-obtener-las-horas-entre-2-variables-que-son-de-tipo-template-pero-que-tienen-como-valor-fecha/86529/3 "2026-03-02T02:28:34Z")

</div>

I’m using template, because I want to build in a field two values, they are: date and time, but time is just hour like a number integer, not decimals ☹ or have you other idea that I can work?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 2, 2026, 2:40am UTC](https://community.glideapps.com/t/quiero-obtener-las-horas-entre-2-variables-que-son-de-tipo-template-pero-que-tienen-como-valor-fecha/86529/4 "2026-03-02T02:40:23Z")

</div>

So you want the user to select Date and Time separately?

The below template might be of interest. It allows for separate date and time selection, but saves both Start datetime and End datetime as single datetime columns. You may be able to adapt the technique.

> **[Time Selection Concept](https://go.glideapps.com/template/P2OgJ8sjHaqP68jkVfQl-template-published?privateTemplateToken=zd7BSk8DF3GVLYscwhDx)**