Calculating Session Duration with a Single Formula

There is an Excel file that teaches how to perform the Calculating Session Duration with a Single Formula operation.

Excel Powered Calculating Session Duration with A Single Formula

This file calculates active session duration from employee login-logout logs using a single formula. It also analyzes Login, Logout, Lock, and Unlock events to determine each session's start and end times. Thus, lock durations are automatically subtracted from active time. Consequently, LET, MAP, FILTER, and SUMPRODUCT functions are used together. As a result, the dynamic array formula ensures that results are updated automatically.

Hope it is useful.