1 Reply Latest reply on Aug 19, 2018 8:59 AM by Shinichiro Murakami

    Time difference between date field from and dimension

    sunny p

      I am trying to calculate difference in time based on these data                       

      member(A)               Start time(B)                                   Entry login (c)                           Entry logout (D)                       End time(E)                         Difference in time(F)

                   abc             b1)   1/23/2018 12:30:21 PM                                                                                                                                                                        1min( c1-b1)

                   abc                                                                c1)  1/23/2018 12:31:21 PM      D1)  1/23/2018 12:40:50 PM                                                                   2min (C2-D1)

                  abc                                                                 c2) 1/23/2018 12:42:50 PM      D2)  1/23/2018 12:52:20 PM                                                                    58min (C3-D2)

                   abc                                                               c3) 1/23/2018 13:50:20 PM       D3) 1/23/2018 13:52:20 PM                                                                    1min (E1-D3)

                                                                                                                                                                                               E1) 1/23/2018 13:53:20 PM      

      "Start time" and "End time" are the two direct fields which depend on "status flag",consists of login, logout and entry. Based on entry, column C and column D calculated.

      Now how to calculate difference in time(F) if there is no entry login and entry logout status flag. I need to get difference in minutes. Can some one help me with this.