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.
Could you please attach sample data hopefully as twbx or excel is also fine.