View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pat
 
Posts: n/a
Default Making a timesheet!!!

How can I, just by inserting work period eg 8 16, afterwards in 2 cells see
all hours between 18 and 22 and hours between 22 and 5:15? Eg as written he
working time evening hours night hours
Patricia 12 20 2 0
Maria 16 24 4 2
-Where I only have to write the working time and excel calculates the
rest... I'm really having difficulties. Thanks!