I am trying to get total time (in hours) spend per day, currently I have:
- Login time
- Logout time
- Break time
When logout time exceed 12 AM (00:00), in duration field I see
8 hrs 20 mins ago.
Value for Login time: 10:20 (AM), Logout time: 05:00 (AM), Breaks 3 hours.
Formula I am using is (Logout - login - breaks), my expectation was duration be:
16 hrs 40 mins, please help me rectify this mismatch