Forum Discussion
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 ...
So I did it , maybe it's not the right way , but i got the results that I wanted . Basically I Marked like to the first End Session I marked the number 1 , to the 2nd End Session , number 2 etc ... After That I find MINIFS from the Date/Time Start column for the session number and the MAXIFS for the Date/Time Finish for the session number . Then MAXIFS-MINIFS was the time difference . Thanks for the replies