Greetings!
I'm creating spreadsheets to show how many people were "on the clock" at each hour interval for each day of the week.
I'm currently adding the information manually, but it's incredibly time consuming, and as with the example below, the data keeps changing so I'd rather have a formula to get it to automate! Any suggestions?
This is the result I'm looking for : (B2- 1 person works on Mondays from 12am to 1am) TIA!
from data like this:
I'm creating spreadsheets to show how many people were "on the clock" at each hour interval for each day of the week.
I'm currently adding the information manually, but it's incredibly time consuming, and as with the example below, the data keeps changing so I'd rather have a formula to get it to automate! Any suggestions?
This is the result I'm looking for : (B2- 1 person works on Mondays from 12am to 1am) TIA!
from data like this: