Skip to Content
0
Former Member
Sep 21, 2016 at 05:48 PM

Adding Time Fields

19 Views

I have a Date-Time field that I need to add to a calculated time formula.

Ex.

{Table.Date-Time} contains data like 09/21/2016 11:11:59 AM

{@Hours} contains data like 1.51 hours

I have tried the following:

TIME({Table.Date-Time} + ({@Hours}/3600)

or TIME({Table.Date-Time} + ({@Hours})

Either one of these are giving me an "Numeric Overflow".

In the above example, my expected output is 12:42:05 PM. I do not need the date, just the time.

I am not sure what to do or how to change the formula.

Thanks in advance.