# (Duration \* $) to get a fee

**URL:** <https://community.glideapps.com/t/duration-to-get-a-fee/41828>\
**Category:** Ask for Help\
**Created:** [May 10, 2022, 5:48pm UTC](https://community.glideapps.com/t/duration-to-get-a-fee/41828 "2022-05-10T17:48:17Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jonathon\_Kohn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonathon_kohn/32/8593_2.png) [@Jonathon\_Kohn](https://community.glideapps.com/u/Jonathon_Kohn)\
**Post date:** [May 10, 2022, 5:48pm UTC](https://community.glideapps.com/t/duration-to-get-a-fee/41828/1 "2022-05-10T17:48:17Z")

</div>

I’m trying to use a math column to calculate a storage fee ($0.10 per day per item) allowing the user to input date and item count. The math column won’t allow me to format $ and forces duration due to using dates. Am I missing something?

---

<div class="post-metadata">

**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 10, 2022, 5:50pm UTC](https://community.glideapps.com/t/duration-to-get-a-fee/41828/2 "2022-05-10T17:50:43Z")

</div>

the whole column needs to be in the same format

---

<div class="post-metadata">

**Author:** ![Jonathon\_Kohn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonathon_kohn/32/8593_2.png) [@Jonathon\_Kohn](https://community.glideapps.com/u/Jonathon_Kohn)\
**Post date:** [May 10, 2022, 5:57pm UTC](https://community.glideapps.com/t/duration-to-get-a-fee/41828/3 "2022-05-10T17:57:43Z")

</div>

So how do I turn (now - 30 days ago) into “30” instead of 720:00:00?

---

<div class="post-metadata">

**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\
**Post date:** [May 10, 2022, 6:24pm UTC](https://community.glideapps.com/t/duration-to-get-a-fee/41828/4 "2022-05-10T18:24:01Z")

</div>

If i was in your situation i will use google sheet to convert date to be number then i will use the math. You might need to dublicate the currency column and use the dublicated column as number too. Try

---

<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:** [May 10, 2022, 6:55pm UTC](https://community.glideapps.com/t/duration-to-get-a-fee/41828/6 "2022-05-10T18:55:04Z")

</div>

> [@Jonathon\_Kohn](#):
>
> So how do I turn (now - 30 days ago) into “30” instead of 720:00:00?

Use either trunc or round in your math formula (this behaviour changed a few months ago)

---

<div class="post-metadata">

**Author:** ![Jonathon\_Kohn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonathon_kohn/32/8593_2.png) [@Jonathon\_Kohn](https://community.glideapps.com/u/Jonathon_Kohn)\
**Post date:** [May 10, 2022, 7:01pm UTC](https://community.glideapps.com/t/duration-to-get-a-fee/41828/7 "2022-05-10T19:01:27Z")

</div>

Thank you!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [May 11, 2022, 7:01pm UTC](https://community.glideapps.com/t/duration-to-get-a-fee/41828/8 "2022-05-11T19:01:33Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.