View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default How to write the formula for time accounting for a work schedule

I am working an employee schedule and I want to find the formula to make a
cell add the amount of hours used or assigned for a given day and give me the
results in hours. Such as I schedule someone to work 1100 (11am) - 1800 (6pm)
how can I get excel to see that there are 7 hours that were scheduled and
give me the results back as 7 hours or such. I then want to take that and add
all the cells with the time and tell me the number of hours that a individual
was scheduled to work for a given week to compute my labor cost