Add & Subtract seconds from time

[bittubadri]

D2=07-26-2022 2:30:00 PM
E2=10
In F2=I want to add E2 seconds to D2
In G2=I want to subtract E2 from D2

How to accomplish?

[bebo021999]

what is actual D2 value? text string or value formatted as date-time?

Try:
F2= D2 + E2/86400

what the result?

[bittubadri]

Hi bebo021999

It is value formatted as date-time

[bebo021999]

So, does the #2 work?