# Adding time to Date/Time field

**URL:** <https://forums.knack.com/t/adding-time-to-date-time-field/19937>\
**Category:** Get Answers\
**Created:** [October 6, 2025, 8:03am UTC](https://forums.knack.com/t/adding-time-to-date-time-field/19937 "2025-10-06T08:03:59Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![houwtama](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/houwtama/32/5235_2.png) [@houwtama](https://forums.knack.com/u/houwtama)\
**Post date:** [October 6, 2025, 8:03am UTC](https://forums.knack.com/t/adding-time-to-date-time-field/19937/1 "2025-10-06T08:03:59Z")

</div>

I would like to create a field which adds 1 hour to an existing date/time field. I have set up my equation as per the attached pics. Even though I set the “Date Type” to “hours”, the formula continues to add one DAY to the date.

Any help much appreciated.

 ![Date:Time 2](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/e/eae33f235d80c83fbcba4f265fd84b65512fdad6.jpeg)

 ![Date:Time 1](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/6/68a8560de78f455063eaaae3bb4019f2d2bd838d.jpeg)

---

<div class="post-metadata">

**Author:** ![Dean2](https://avatars.discourse-cdn.com/v4/letter/d/bcef8e/32.png) [@Dean2](https://forums.knack.com/u/Dean2)\
**Post date:** [October 6, 2025, 10:53pm UTC](https://forums.knack.com/t/adding-time-to-date-time-field/19937/2 "2025-10-06T22:53:54Z")

</div>

Hi

I’m not sure of your ultimate objective doing this but this is how we add a “time” to a date which might be of some help.

We have 4 fields being the date, the time, an equation field to convert the time, and then a field combining the date and the converted time.

The time field is a Date/Time field being:

Date Format = Ignore Date

Time Format = HH:MM

Default Time = None

So, your “+ 1 hour” might be 01:00 for example.

The 3rd field is an Equation field converting the time like this:

floor(({Scheduled Start Time} / 60000) % 1440) / 60

Being:

Equation Type = Numeric

Result Format = Decimals = Period & Decimal Places = 2

Rounding = Default

Thousands delimiter = None

Number Format = None

The 4th field is an Equation field combining the date and converted time:

{Shift Date}+({Equation for Start Time}/24)

Being:

Equation Type = Date

Date Type = Days

Result Type = Date

Date Format = Ignore Date

Time Format = HH:MM

![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/e/e3d6918b6b404c36efc7b06192ce14c5f3d3df4c.png)

Hopefully, I’ve included all the steps and this helps.

Dean

---

<div class="post-metadata">

**Author:** ![houwtama](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/houwtama/32/5235_2.png) [@houwtama](https://forums.knack.com/u/houwtama)\
**Post date:** [October 7, 2025, 10:28am UTC](https://forums.knack.com/t/adding-time-to-date-time-field/19937/3 "2025-10-07T10:28:15Z")

</div>

Hi Dean,

Many thanks for your meticulously laid-out solution. I’m going to give it a go now.

Regards, John

---

<div class="post-metadata">

**Author:** ![houwtama](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/houwtama/32/5235_2.png) [@houwtama](https://forums.knack.com/u/houwtama)\
**Post date:** [October 7, 2025, 12:18pm UTC](https://forums.knack.com/t/adding-time-to-date-time-field/19937/4 "2025-10-07T12:18:51Z")

</div>

So, this is the context. I’m wanting to express a date/time field,with a time that is one hour ahead of my local time. This is so that I can send students a lesson reminder using their local time.

**First:**

I separated my local date and time fields.

 ![Date:Time 3](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/d/d1e9e4d9d89cb3e7b541149c5c073c1d74b2fa57.jpeg)

**Second:**

I used this equation in an equation field to add one hour to the time.

((({Time} / 60000)%1440)/60) +1

 ![Date:Time 4](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/7/7b6d46a8ec79d3c927e063306cb01315590ec92f.jpeg)

**Third:**

I used this equation field to put the new date and time together.

 ![Date:Time 5](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/4/4c5d8861f851873525511f8211dfca07c3f2ef24.jpeg)

… and viola! all is good!

Thanks Dean!

---

<div class="post-metadata">

**Author:** ![houwtama](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/houwtama/32/5235_2.png) [@houwtama](https://forums.knack.com/u/houwtama)\
**Post date:** [October 7, 2025, 12:43pm UTC](https://forums.knack.com/t/adding-time-to-date-time-field/19937/5 "2025-10-07T12:43:51Z")

</div>

Mmm… not so fast…

Added an additional equation field to give me a Local Date/Time field for my calendar, opened up the grid to see all the records and…

 ![Date:Time 6](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/c/cee3d27da08c9521df146443157b156eae3e20d1.jpeg)

A calamity of gobbledegook! No idea as to why the last record differs from the others, when the equation applies to all and the time in consistent.

---

<div class="post-metadata">

**Author:** ![Dean2](https://avatars.discourse-cdn.com/v4/letter/d/bcef8e/32.png) [@Dean2](https://forums.knack.com/u/Dean2)\
**Post date:** [October 7, 2025, 8:00pm UTC](https://forums.knack.com/t/adding-time-to-date-time-field/19937/6 "2025-10-07T20:00:16Z")

</div>

Hi

Sorry, I misunderstood what you were after.

Here’s the calculation I use to calculate a time 1 hour before a shift is due to start so that we can trigger a reminder off it.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/5/5678a15a93b616e82169287a25160fce7dfcd71c.png)

Note that the Date Type is Hours and not Days.

Dean

---

<div class="post-metadata">

**Author:** ![houwtama](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/houwtama/32/5235_2.png) [@houwtama](https://forums.knack.com/u/houwtama)\
**Post date:** [October 8, 2025, 11:01am UTC](https://forums.knack.com/t/adding-time-to-date-time-field/19937/7 "2025-10-08T11:01:47Z")

</div>

Many thanks Dean. 👏 Much obliged to you for the help!

---

<div class="post-metadata">

**Author:** ![Phillip2](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/phillip2/32/5528_2.png) [@Phillip2](https://forums.knack.com/u/Phillip2)\
**Post date:** [January 5, 2026, 4:58pm UTC](https://forums.knack.com/t/adding-time-to-date-time-field/19937/8 "2026-01-05T16:58:42Z")

</div>

Good question @houwtama . @Dean2 , I was able to use your solution with a fixed number, as below.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/4/4d057c10ac6b4c741aa58a0bfea2daa63ea3fe20.png)

However, when I swap out the fixed number for a number field (in this case, a Max number field containing numbers such as 1, 4, 12, 24, etc.), it doesn’t work. What’s going on?

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/e/eba977598c99ff20a3c7c3e7ffb26d72da4133ff.png)

---

<div class="post-metadata">

**Author:** ![Dean2](https://avatars.discourse-cdn.com/v4/letter/d/bcef8e/32.png) [@Dean2](https://forums.knack.com/u/Dean2)\
**Post date:** [January 5, 2026, 10:05pm UTC](https://forums.knack.com/t/adding-time-to-date-time-field/19937/9 "2026-01-05T22:05:49Z")

</div>

Hi Phillip

While I can’t tell you what is going on, have you tried creating a number field and using a conditional rule to populate the new number field with your {Max REI of applied products} field values, and then trying to add this number to your {Application finish date and time} field?

Dean

---

<div class="post-metadata">

**Author:** ![Phillip2](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/phillip2/32/5528_2.png) [@Phillip2](https://forums.knack.com/u/Phillip2)\
**Post date:** [January 13, 2026, 8:37pm UTC](https://forums.knack.com/t/adding-time-to-date-time-field/19937/10 "2026-01-13T20:37:09Z")

</div>

Hi @Dean2 ,

Your solution worked, thanks! It must be some quirk of the coding that doesn’t recognize (or properly format) a ∑ field. When I set up the number field with a conditional rule to set to a field value of {Max REI of applied products}, and then added this new number field to the {Application finish date and time} field, everything calculated as it should. Thanks again!
