I have a spreadsheet where I collect the start and end time of each shift and the number of people working during those times.
I want the users to be able to change the start and end times and number of people working.
I also have a table with 24 hrs , each cell representing 1 hour. e.g. 0:00, 01:00, 02:00, etc.
How can I:
1. calculate the number of people working each hour
2. re-calculate that hour when the shift start and end times change.
Any help would be greatly appreciated as I'm a novic at this.
Thanks
Bookmarks