# Weird format in a table cell

**URL:** <https://community.glideapps.com/t/weird-format-in-a-table-cell/80323>\
**Category:** Ask for Help\
**Created:** [February 25, 2025, 12:08pm UTC](https://community.glideapps.com/t/weird-format-in-a-table-cell/80323 "2025-02-25T12:08:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Liliz](https://avatars.discourse-cdn.com/v4/letter/l/bc8723/32.png) [@Liliz](https://community.glideapps.com/u/Liliz)\
**Post date:** [February 25, 2025, 12:08pm UTC](https://community.glideapps.com/t/weird-format-in-a-table-cell/80323/1 "2025-02-25T12:08:57Z")

</div>

Hello everyone.

I’m trying to calculate what week of pregnancy the user is and their progress (in percentage).  
I created math columns, and it gives me weird formats (as on the picture)

 ![2025-02-25_13h07_20](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/3/83c6b26b5071ee444469340478ffe1f5f6923bc0.png)

When i double click on the cells, I see that the result is correct, but it doesn’t want to display it whatsoever. It only stays with the format 333:33:33.

 ![2025-02-25_13h05_37](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/1/416373dae94c137b3cc065d8a417f843971202bc.png)

Help please ?

---

<div class="post-metadata">

**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:** [February 25, 2025, 1:10pm UTC](https://community.glideapps.com/t/weird-format-in-a-table-cell/80323/2 "2025-02-25T13:10:34Z")

</div>

What you see is a number formatted as a duration in Hours:Minutes:Seconds.

Try Trunc(), Floor(), Ceiling(), or Round() in your math formula.