How can I add minutes to a timestamp? If I'v...

[MultiTech]

How can I add minutes to a timestamp?

If I’ve got a column that’s a Time, and a column that’s a number, and I want to add the minute equivalent of the number entered/selected… how?

For the examples below, let’s assume that: TimeNow() = “08:00:00”, and [Log_Start_Mod_Minutes] = 1 (number type)

----- You cant add a number, for this adds the hour equivalent of what you’ve entered.

-> TimeNow() + 1 = “09:00:00” (aka, plus one hour)

-It’s valid: https://cl.ly/2a541ed1f97a

The result: https://cl.ly/9132c8444eff < plus one hour

---

You can’t divide the number entered/selected by 60 to get the decimal, because that truncates to 0.

-> TimeNow() + 1/60 = “08:00:00” (1/60 = 0 so no change)

-It’s valid: https://cl.ly/2e9381a7cd04 | https://cl.ly/09c08ebe55ea

The result: https://cl.ly/04a64b77b121 | https://cl.ly/e73cd699ac0f < no change (for both)

---

You can’t concatenate together a duration, using the number entered as the minutes, and add that to the timestamp

-> TimeNow() + concatenate(“000:”, [Log_Start_Mod_Minutes], “:00”)

-It’s NOT valid: https://cl.ly/771e462e644c

---

But you can hard code it

-> TimeNow() + “000:01:00” = “08:01:00” (aka, plus one minute)

-------------------------------------- I believe this is the culprit of my issue: (https://cl.ly/3051dc94dc07) <- there are only two data types allowed to operate with the Time type:

number and duration.

Can we get decimal added to this list?

Other than something like that… anyone got any suggestions on how I can add minutes to a timestamp?

@praveen @Adam_Stone_AppSheet