Add Hours/Minutes/Seconds Function


I know there are functions to add months and days:

  • ADD : Add Days Function [=ADD(<date>,<days>] .
    Adds days to date values.
  • ADM : Add Months Function [=ADD(<date>,<months>] .
    Adds months to date values.

But is there a function that adds hours, minutes or seconds?

ADS adds seconds try that.

1 Like

Hey @Jesse, I tried it but it doesnt seem to work. I think this is right format no?

[=ADS('{TICKET TIME}','900')]

This one doesnt work either

[=FT(ADS('{TICKET TIME}',900),'HH:mm')]

Have to use formatted {TICKET DATE} NOT {TICKET TIME}

1 Like