Thread: [Solved] Noob here - I need a shift calendar by days with count of shift.
View Single Post
 
Old 09-07-2012, 02:06 PM
freeman freeman is offline Windows 7 32bit Office 2007
Novice
  
Join Date: Sep 2012
Posts: 8
freeman is on a distinguished road
Default
This is what I have and I am stuck on the fact that it is calculating the day as 24 hours instead of as a shift of 8 hours. Could someone please take a look and adjust.

I need to enter the day, the time a shift starts, how many shifts it takes, then calculate the start and final day and shift.

Thanks
Attached Files
File Type: xlsx Calculate Days for Forge.xlsx (8.8 KB, 10 views)
Reply With Quote