Spreadsheet: 846002d1697296300-how-to-count-no-of-employees-per-interval-excel-coverage-template
Sheet: Data

Employee | Dept | Date | StartShift | EndShift | Shift Start | Shift End
[NAME] | SME | Sun, Oct 1 | 06:00:00 | 15:00:00 | 2023-10-01 06:00:00 | 2023-10-01 15:00:00
Romeo | Lead | Sun, Oct 1 | 08:00:00 | 17:00:00 | 2023-10-01 08:00:00 | 2023-10-01 17:00:00
Saloma | Lead | Sun, Oct 1 | 18:00:00 | 03:00:00 | 2023-10-01 18:00:00 | 2023-10-02 03:00:00
Sonson | SME | Sun, Oct 1 | 21:00:00 | 06:00:00 | 2023-10-01 21:00:00 | 2023-10-02 06:00:00
[NAME] | SME | Mon, Oct 2 | 06:00:00 | 15:00:00 | 2023-10-02 06:00:00 | 2023-10-02 15:00:00
Romeo | Lead | Mon, Oct 2 | 08:00:00 | 17:00:00 | 2023-10-02 08:00:00 | 2023-10-02 17:00:00
Mario | Manager | Mon, Oct 2 | 11:00:00 | 20:00:00 | 2023-10-02 11:00:00 | 2023-10-02 20:00:00
Dola | RTA | Mon, Oct 2 | 12:00:00 | 09:00:00 | 2023-10-02 12:00:00 | 2023-10-03 09:00:00
Saloma | Lead | Mon, Oct 2 | 18:00:00 | 03:00:00 | 2023-10-02 18:00:00 | 2023-10-03 03:00:00
Sonson | SME | Mon, Oct 2 | 21:00:00 | 06:00:00 | 2023-10-02 21:00:00 | 2023-10-03 06:00:00
Mario | Manager | Tue, Oct 3 | 11:00:00 | 20:00:00 | 2023-10-03 11:00:00 | 2023-10-03 20:00:00
[NAME] | SME | Tue, Oct 3 | 12:00:00 | 09:00:00 | 2023-10-03 12:00:00 | 2023-10-04 09:00:00
Dola | RTA | Tue, Oct 3 | 12:00:00 | 09:00:00 | 2023-10-03 12:00:00 | 2023-10-04 09:00:00
Saloma | Lead | Tue, Oct 3 | 18:00:00 | 03:00:00 | 2023-10-03 18:00:00 | 2023-10-04 03:00:00
Sonson | SME | Tue, Oct 3 | 21:00:00 | 06:00:00 | 2023-10-03 21:00:00 | 2023-10-04 06:00:00
Mario | Manager | Wed, Oct 4 | 11:00:00 | 20:00:00 | 2023-10-04 11:00:00 | 2023-10-04 20:00:00
[NAME] | SME | Wed, Oct 4 | 12:00:00 | 09:00:00 | 2023-10-04 12:00:00 | 2023-10-05 09:00:00
Dola | RTA | Wed, Oct 4 | 12:00:00 | 09:00:00 | 2023-10-04 12:00:00 | 2023-10-05 09:00:00
Saloma | Lead | Wed, Oct 4 | 18:00:00 | 03:00:00 | 2023-10-04 18:00:00 | 2023-10-05 03:00:00
Sonson | SME | Wed, Oct 4 | 21:00:00 | 06:00:00 | 2023-10-04 21:00:00 | 2023-10-05 06:00:00
[NAME] | SME | Thu, Oct 5 | 06:00:00 | 15:00:00 | 2023-10-05 06:00:00 | 2023-10-05 15:00:00
Romeo | Lead | Thu, Oct 5 | 08:00:00 | 17:00:00 | 2023-10-05 08:00:00 | 2023-10-05 17:00:00
Mario | Manager | Thu, Oct 5 | 11:00:00 | 20:00:00 | 2023-10-05 11:00:00 | 2023-10-05 20:00:00
[NAME] | SME | Thu, Oct 5 | 12:00:00 | 09:00:00 | 2023-10-05 12:00:00 | 2023-10-06 09:00:00
Dola | RTA | Thu, Oct 5 | 12:00:00 | 09:00:00 | 2023-10-05 12:00:00 | 2023-10-06 09:00:00
Sonson | SME | Thu, Oct 5 | 21:00:00 | 06:00:00 | 2023-10-05 21:00:00 | 2023-10-06 06:00:00
[NAME] | SME | Fri, Oct 6 | 06:00:00 | 15:00:00 | 2023-10-06 06:00:00 | 2023-10-06 15:00:00
Romeo | Lead | Fri, Oct 6 | 08:00:00 | 17:00:00 | 2023-10-06 08:00:00 | 2023-10-06 17:00:00
Mario | Manager | Fri, Oct 6 | 11:00:00 | 20:00:00 | 2023-10-06 11:00:00 | 2023-10-06 20:00:00
[NAME] | SME | Fri, Oct 6 | 12:00:00 | 09:00:00 | 2023-10-06 12:00:00 | 2023-10-07 09:00:00
Dola | RTA | Fri, Oct 6 | 12:00:00 | 09:00:00 | 2023-10-06 12:00:00 | 2023-10-07 09:00:00
[NAME] | SME | Sat, Oct 7 | 06:00:00 | 15:00:00 | 2023-10-07 06:00:00 | 2023-10-07 15:00:00
Romeo | Lead | Sat, Oct 7 | 08:00:00 | 17:00:00 | 2023-10-07 08:00:00 | 2023-10-07 17:00:00
[NAME] | SME | Sat, Oct 7 | 12:00:00 | 09:00:00 | 2023-10-07 12:00:00 | 2023-10-08 09:00:00
Saloma | Lead | Sat, Oct 7 | 18:00:00 | 03:00:00 | 2023-10-07 18:00:00 | 2023-10-08 03:00:00
[NAME] | SME | Sun, Oct 8 | 06:00:00 | 15:00:00 | 2023-10-08 06:00:00 | 2023-10-08 15:00:00
Romeo | Lead | Sun, Oct 8 | 08:00:00 | 17:00:00 | 2023-10-08 08:00:00 | 2023-10-08 17:00:00
Saloma | Lead | Sun, Oct 8 | 18:00:00 | 03:00:00 | 2023-10-08 18:00:00 | 2023-10-09 03:00:00
Sonson | SME | Sun, Oct 8 | 21:00:00 | 06:00:00 | 2023-10-08 21:00:00 | 2023-10-09 06:00:00