Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Find the Seconds between the timesinterval

dondapati
7 - Meteor

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)

1 REPLY 1
JosephSerpis
17 - Castor
17 - Castor

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

Labels
Top Solution Authors