View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RJ Swain RJ Swain is offline
external usenet poster
 
Posts: 1
Default Schedule hours calculation

I am putting together a simple excel spreadsheet to calculate hourly
schedules for my employees. What I would like it to do is calculate the hours
of the week and subtract 1 hour per day for lunch hours. So it is setup as
follows

A1 - Name
B1 - Start
C1 - Finish (Monday) (-1 hour lunch)
D1 - Start
E1 - Finish (Tuesday) (-1 hour lunch)
etc..
N1 - Total hours for the week