How can we write a script like Set analysis for below scenario?

[#1]

Hi all ,

I have a issue.

I have two table like

1. StartTime 

2. EndTime

Here, Now if I select the 2:36:07 AM from Endtime means Possible value for starttime is 2:36:07 AM.

But, I want to like below :

If  I select the 2:36:07 AM from Endtime means Possible value for starttime is 2:36:05.

Likewise I need this 2:36:08  -----> 2:36:07.

Thanks In advance.

Regards,

Kabilan K.

[MayilVahanan]

HI

Try like this

     = time(time('2:36:05 AM')-1/(3600*60)) gives 2:36:04 AM

     so, try like this time(time(yourField)-1/(3600*60)) as starttime

     Hope it helps