Hey... I am still not able to get it. The sheet works fine but it's not adding the value to the next day as the day changes after midnight. For example : if I select the shift as 09:00 PM - 06:00 AM in Monday, it should show value (1) in 21:00 - 22:00, 22:00 - 23:00, 23:00 - 00:00 and should ad value (1) in Tuesday -
00:00 - 01:00
01:00 - 02:00
02:00 - 03:00
03:00 - 04:00
04:00 - 05:00
05:00 - 06:00
but it's not doing that. Any help is highly appreciated.
Link to worksheet :
http://snk.to/f-ct9eoae5
Coverage Chart.xls
Bookmarks