Doozer1979
New Member
- Joined
- Mar 6, 2008
- Messages
- 11
Hello All,
I have to analyse a lot of rostering information.
The information comes from a data warehouse in text format and describes what shifts staff are on. The data comes out of the data warehouse in the format hh:mm - hh:mm (ie; 15:00 - 22:00, or 07:00 - 15:00). The shift patterns vary quite a lot.
What i need to do is go through this list and see how many staff i have on in each hour of the day. My thoughts for doing this were to to have another sheet with 24 cells that correspond to each hour of the day, and then have a function that loops through the rostering information and increments the cells by 1 if the shift includes that hour in its range.
Trouble is i have no idea how to do this in excel or vba, or even if i'm going down the right path.
Can anyone offer any advice?
I have to analyse a lot of rostering information.
The information comes from a data warehouse in text format and describes what shifts staff are on. The data comes out of the data warehouse in the format hh:mm - hh:mm (ie; 15:00 - 22:00, or 07:00 - 15:00). The shift patterns vary quite a lot.
What i need to do is go through this list and see how many staff i have on in each hour of the day. My thoughts for doing this were to to have another sheet with 24 cells that correspond to each hour of the day, and then have a function that loops through the rostering information and increments the cells by 1 if the shift includes that hour in its range.
Trouble is i have no idea how to do this in excel or vba, or even if i'm going down the right path.
Can anyone offer any advice?