Find the Seconds between the timesinterval

[dondapati]

Hi to all,

I want to find the number of seconds between the two time stamps but exclude the specific time interval . 

The Condition is should not consider the 2019-09-01 11:00:00 and 2019-09-01 11:30:00 intervals. 

Ex :

         starttime                                   endtime
2019-09-01 10:59:16              2019-09-01 11:14:47

2019-09-01 10:57:58              2019-09-01 11:51:08

2019-09-01 11:05:00              2019-09-01 12:10:40

2019-09-01 10:54:29              2019-09-02 09:56:58

2019-09-01 11:00:15              2019-09-01 11:12:48

Expected Output :

   starttime                                   endtime                                             Seconds
2019-09-01 10:59:16              2019-09-01 11:14:47                                   17             (Here Consider the starttime upto 11.00)

2019-09-01 10:57:58              2019-09-01 11:51:08                                    1390        (Here consider starttime upto 11.00 and after 11.30)

2019-09-01 11:05:00              2019-09-01 12:10:40                                    2448

2019-09-01 10:54:29              2019-09-02 09:56:58                                                     (Here consider upto next day but eliminating condition)

2019-09-01 11:00:15              2019-09-01 11:12:48                                         0          (Should not consider it present in the interval)

[JosephSerpis · Accepted solution]

Hi @dondapati I think I mocked up something that answers your question. Let me know what you think?