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)
Solved! Go to Solution.
Hi @dondapati I think I mocked up something that answers your question. Let me know what you think?