Forum Discussion
IgecBt
Sep 21, 2023Copper Contributor
Time difference
Hello all , This is my first post EVER anywhere 🙂 I would like to calculate the time spent for each session . Basically RED cell - GREEN cell = BLUE cell . Now the thing is that RED cell could be ...
SergeiBaklan
Sep 21, 2023Diamond Contributor
IgecBt
Sep 21, 2023Copper Contributor
SergeiBaklan Hey , Thanks for the reply . Maybe I wasn't clear . The green part is one session , the red part is second session and so on . Let's take for example the Green part . In it the green cell is earliest date/time start , the red cell is the latest date/time Finish before a new session begins . SO red cell - green cell gives result in blue cell ( 9-1-23 19:13 - 9-1-23 17:45 = 01:28:00)
- HansVogelaarSep 21, 2023MVP