# Create Countdown **URL:** \ **Category:** Ask for Help\ **Created:** [January 14, 2022, 5:19pm UTC](https://community.glideapps.com/t/create-countdown/37186 "2022-01-14T17:19:10Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![CamilleBarbe](https://avatars.discourse-cdn.com/v4/letter/c/ecccb3/32.png) [@CamilleBarbe](https://community.glideapps.com/u/CamilleBarbe)\ **Post date:** [January 14, 2022, 5:19pm UTC](https://community.glideapps.com/t/create-countdown/37186/1 "2022-01-14T17:19:10Z")
Bonjour, je veux créer un décompte sur mon application. Pour cela j’ai recueilli à leur connexion le jour et l’heure de leur arrivée. Je veux ensuite faire une colonne (Heure de connexion + 1h30) pour la relier à mon compteur et la définir comme heure de fin du challenge( que j’ai réussi à faire) Je bloque plus que sur cette formule que je ne trouve pas Merci de votre aide ---
**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:** [January 14, 2022, 5:28pm UTC](https://community.glideapps.com/t/create-countdown/37186/2 "2022-01-14T17:28:28Z")
Do you mean the formula to add 1h30m to your start date and time? Date math in glide calculates the number of days between two dates. So to add 1h30m, you need to get the decimal form of 1.5 hours in days. Each hour is approximately 0.0417 days and an hour and a half is approximately 0.0625 days. You can either use a math column and add 0.0625 to your date, or you can do the math like this: `DATE + (1/24*1.5)` That should give you the end date and time that is 1.5 hours after the start date time. ---
**Author:** ![CamilleBarbe](https://avatars.discourse-cdn.com/v4/letter/c/ecccb3/32.png) [@CamilleBarbe](https://community.glideapps.com/u/CamilleBarbe)\ **Post date:** [January 14, 2022, 5:35pm UTC](https://community.glideapps.com/t/create-countdown/37186/3 "2022-01-14T17:35:40Z")
Oh super ! Oui ca fonctionne. Maintenant je veux utiliser la formule “Mod((Stop-Now)\*86400,60)” pour calculer mes secondes Stop= l’heure que je viens de calculer grâce à vous Now= l’heure actuel Cela me marque “Invalid operation on date/time” pourquoi ? et comment faire pour que cela fonctionne ? ---
**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:** [January 14, 2022, 5:46pm UTC](https://community.glideapps.com/t/create-countdown/37186/4 "2022-01-14T17:46:26Z")
Is 60 your divisor for the MOD? Try using a comma `,` instead of a decimal `.` ---
**Author:** ![CamilleBarbe](https://avatars.discourse-cdn.com/v4/letter/c/ecccb3/32.png) [@CamilleBarbe](https://community.glideapps.com/u/CamilleBarbe)\ **Post date:** [January 14, 2022, 5:48pm UTC](https://community.glideapps.com/t/create-countdown/37186/5 "2022-01-14T17:48:52Z")
Oui c’est mon divisuer, j’ai déja une virgule, je ne peux pas la remplacer par autre chose ---
**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:** [January 14, 2022, 6:01pm UTC](https://community.glideapps.com/t/create-countdown/37186/6 "2022-01-14T18:01:35Z")
Can you show some screenshots of your data? I’m curious how you have your Stop and Now columns values set up. ---
**Author:** ![CamilleBarbe](https://avatars.discourse-cdn.com/v4/letter/c/ecccb3/32.png) [@CamilleBarbe](https://community.glideapps.com/u/CamilleBarbe)\ **Post date:** [January 16, 2022, 2:25pm UTC](https://community.glideapps.com/t/create-countdown/37186/7 "2022-01-16T14:25:52Z")
![1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/a/aaa2ada5957ee2116e7eee610ff64c6ebc08e8f5.png) ![2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/9/097d94d38df0218bf75e00957c9c40390c0c8344.png) ![3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/4/748825cefde8af8ff76aae8d52867e602d9f82a3.png) ![4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/82827b839dad70a23db43fb3dcf24bf8e32ca40d.png) ![5](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/a/ea0c5b5c233911870411ede425160c32265f2cf5.png) ---
**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:** [January 16, 2022, 3:59pm UTC](https://community.glideapps.com/t/create-countdown/37186/8 "2022-01-16T15:59:31Z")
In both your mins-remaining and secs-remaining columns, you do not have a replacement value set up for ‘Stop’. Looks like it won’t calculate anything because there is no stop column selected. I assume that ‘Stop’ should be replaced with Heure de fin? ---
**Author:** ![CamilleBarbe](https://avatars.discourse-cdn.com/v4/letter/c/ecccb3/32.png) [@CamilleBarbe](https://community.glideapps.com/u/CamilleBarbe)\ **Post date:** [January 17, 2022, 9:28am UTC](https://community.glideapps.com/t/create-countdown/37186/9 "2022-01-17T09:28:25Z")
Oui car j’avais l’erreur. Mais je viens de trouver, je n’avais pas sélectionné la bonne colonne. Merci énormément à vous pour votre aide !!!