View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DougAS DougAS is offline
external usenet poster
 
Posts: 1
Default deduct 30 minutes from a shift calculation in hours

Using Excel, I want to build a spread sheet for up to 10 employees on
different shifts to calculate hours scheduled. I have this part, but what I
need to do now is to deduct the lunch time, say 30 minutes, from the total
hours initially calculated.