Forum Discussion
TaroGulati
1 year agoHelper III
Time difference two tables
Hi all, I am having difficulty in calculating the time difference between two tables. I need to calculate sum of time difference from table 2 between type A and B which is 21 min. Thi...
TaroGulati
1 year agoHelper III
Hi, that i calculated using the min date for A and min date B for each combination and then summed up.
ryan_mayu
1 year agoSuper User
- TaroGulati1 year agoHelper III
Hi, thanks for the feedback. in this case result should be 11 not 10. Agree?
- ryan_mayu1 year agoSuper User
totally 21 mins, then substract 6 mins from row 2 and 5 mins from row 3.
21-6-5=10.
if I misunderstood the calculation logic, pls correct me.
- TaroGulati1 year agoHelper III
Hi, yes you are correct.
Thanks