# Add Duration to Datetime

**URL:** <https://community.noloco.io/t/add-duration-to-datetime/1754>\
**Category:** Ask for Help\
**Created:** [February 27, 2025, 5:32pm UTC](https://community.noloco.io/t/add-duration-to-datetime/1754 "2025-02-27T17:32:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![cizict](https://avatars.discourse-cdn.com/v4/letter/c/b4bc9f/32.png) [@cizict](https://community.noloco.io/u/cizict)\
**Post date:** [February 27, 2025, 5:32pm UTC](https://community.noloco.io/t/add-duration-to-datetime/1754/1 "2025-02-27T17:32:32Z")

</div>

Hello, i have a date field Start Date (formated as datetime) and a duration field. I would like to create a Formula field to add the duration field to the Start date field to give an ‘End Date Time’ field e.g.

27/02/2025 17:30:00 + 00:30:00 = 27/02/2025 18:00:00

I have attempted to do this with via a formula by adding the duration field to the start date and wrapping this in TODATE but that is not giving me the correct result.

Any ideas?

---

<div class="post-metadata">

**Author:** ![garyGHL](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/garyghl/32/555_2.png) [@garyGHL](https://community.noloco.io/u/garyGHL)\
**Post date:** [February 28, 2025, 11:21am UTC](https://community.noloco.io/t/add-duration-to-datetime/1754/2 "2025-02-28T11:21:07Z")

</div>

No sure if this is useful but its how I do something very similar.

**TODATE(DATE(YEAR(Signedupdate) + Mortgage Term + 7,MONTH(Signedupdate),DAY(Signedupdate)))**

Signedupdate is my Start Date, Mortagage Term would be you duration, then I add 7 years, you would remove that bit.

**28/02/2025 + 30 + 7 = 28/02/2062**

---

<div class="post-metadata">

**Author:** ![cizict](https://avatars.discourse-cdn.com/v4/letter/c/b4bc9f/32.png) [@cizict](https://community.noloco.io/u/cizict)\
**Post date:** [February 28, 2025, 12:39pm UTC](https://community.noloco.io/t/add-duration-to-datetime/1754/3 "2025-02-28T12:39:31Z")

</div>

Cheers Gary! Appreciated. I’ll have a play around with that formula.
