Staffing with 15mins Interval minus on break/lunch

[kyoyacchi]

Hi!

I was trying to create a Google Spreadsheet or Excel to show staffing depending on Interval and Date Selected.

Column A
Agent 1
Agent 2
Agent 3
Agent 4
Agent 5

Column B (Shift Start Time)
Date&time
Date&time
Date&time
Date&time
Date&time

Column C (Shift End Time)
Date&time
Date&time
Date&time
Date&time
Date&time

Column D (First Break 15mins)
Date&time
Date&time
Date&time
Date&time
Date&time

Column E (Second Break 15mins)
Date&time
Date&time
Date&time
Date&time
Date&time

Column F (Lunch 1hr)
Date&time
Date&time
Date&time
Date&time
Date&time

Column G (Intervals)
8:00 am
8:15 am
8:30 am
8:45 am
9:00 am
... Until 11:45pm

Column H (Staffing)
Total count per Interval minus those on break/lunch

I'm currently using a mobile device and it's hard to place it on Excel/Google Sheet

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook, which should include some rows of dummy data and expected results.

[kyoyacchi]

I understand. It's kinda hard to create one using mobile device.

But here's a sample data

[AliGW]

Is this for Google Sheets?

[AliGW]

That's not a sample, and it's full of errors - not what I asked for.

A sample workbook is 10-15 rows of DUMMY representative data that shows what you have and what you want. Column H isn't even a value column - it contains text.

And again: is this for Google Sheets?

If you want help, you are going to have to try a bit harder.