Add Hours/Minutes/Seconds Function

V5 Question
1

Hi,

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?

2

ADS adds seconds try that.

1 Like
3

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')]
4

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

[=FD(ADS('{TICKET DATE:HH.mm}',900),'hh:mm')]
1 Like