View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jlavallee25 Jlavallee25 is offline
external usenet poster
 
Posts: 1
Default excel employee schedule

I am making an employee schedule names down the left days on the top
i want to schedule justin 7-5 m-f and i want to have a total hours colum, so
I am looking for a function that would make 7-5 = a 10 hour day and have it
also subtract either a 1 or 1/2 hr lunch so the total should = 45 hours