I am trying to calculate different measures for TIME calculation. The file contains the joining and leaving by students several times in the online class.
The issue is to calculate the summing up Total Time during a lecture. Also the Total Time (Hours, Minutes) during the whole semester. Also, there is need to count No. of students at any specific time (Minute granularity).
Now, I got the following graph by taking Live Data in the model.
I used TIME and Date Table for this purpose.
Model Data.xlsx (44.1 KB)
The snapshot of Model view is attached here.